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
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