Reports & Tables

[Thecherub]

I have 3 tables linked through the same Employee Id.

two of the tables are for time off booked and time off history.

the Time off data is in a list box one of the items on that list is "Vacation" is it possable to do a count of these entries on both tables and add them together on a report.

I can do both with a query seperatly but not together. I keep getting errors when i try

 

[jeremie_ingram]

I’m not sure exactly what you are getting at in the question. A bit of punctuation would make it more understandable.

Try this; it might be what you want. If you can do it separately in the queries, create a field within a new query that hold the statements from the individual queries.

VacTot: (COPY AND PAST THE CALCULATION FROM ONE QUERY HERE) + (COPY AND PASTE THE SECOND ONE HERE)

 

[Thecherub]

Ok I get that But....

How do i find that calculation? The Query has the Fields Lastname, FirstName, Time Off Booked (Vacation as the Criteria)and then a count of the Time Off Booked.

The second Query is the same but Time Off History replaces Time off Booked.

Could the Join bettween the tables be interfering?