Thank you for providing the attached file. However, I do have some questions about the document:

1) In the first image, what do the "days" columns refer to? Are they based on the Departure and Arrival dates?

2) What is the purpose of 'Estimate 11-2008'? Will an 'Actual 11-2008' section be needed?

3) How is the ADJ column calculated?

4) What are the meanings of the columns in the second image?

5) Which information is currently tracked in Access and which information is currently tracked in Excel?

I may be able to assist you further if I know the answers to those questions; however, my first thought as far as tracking this information in an Access database is below:

1) I would create a table called 'Leave' with the following fields: ID, person (FK), estimated departure date, estimated arrival date, actual departure date, estimated departure date, location (FK), ADJ

Since there is the location foreign key in the table, you can create a query from the table that groups by location, then, if there are actual values filled in, then the leave days are summed; otherwise, the estimated leave days are summed.

Please let me know if this helps; again, if you could explain the existing structure of your data and the meaning of the values in the attachment you provided, I can give you more help.