Combine multiple reports

  • Thread starter Thread starter BrookieOU
  • Start date Start date
B

BrookieOU

I have a table that lists employee information. Our employees must go
through TB tests, State Sanction Checks and Background checks yearly. I
store the date of their last test in corresponding columns in the "Employee"
table. Then, I have set up a query to show those employees who are over a
year old on the date. I had to set-up a separate query for each column (i.e.
TB test, Sanction and background) because each date for each employee could
fall in a different month and I didn't know if I could do all three in one
query (Anyway I couldn't figure it out).

My question is, can I combine the results from each query all into one report?

Thanks,
Brooke
 
Brooke,

Why not have three conditions for the WHERE clause of your query to select
employees who are overdue on the TB test OR are overdue on the State test OR
are overdue on the background check?

In the Access query design tool, you will notice that there are many lines
in the criteria section. Criteria on different lines are treated as OR
conditions. On the first line, put your TB criteria - < DateAdd("m", -12,
Date()). On the second line, add the same criteria under your State test
column, and on the third line, add the criteria under the background check
column.

One note - if you have other criteria you must list them on each line.
 
Back
Top