Help with comparing queries

  • Thread starter Thread starter Abbey
  • Start date Start date
A

Abbey

I'll try to explain this the best I can... I am making a database for my work
to hold all of their training records. So basically I have a table that has
all of the current Document Numbers, their Titles, Revision Levels and
Effective Dates. Then, for each employee I have a table that holds which
documents they've been trained to and at what revision level. Lastly, I have
queries for each Job Title saying what documents someone with that job title
would need to be trained to.

Having said all that, my question is, is there a way to check the individual
employee's training record to see if they have the most recent revision for
their Job Title?

I appreciate any help you can give me. Thanks!
 
not sure that there is anything regarding macros for this....

One can get creative with a Duplicates Unmatched query; compary a query of
MaxRevision with a query of EmployeeRevision.....
 
Back
Top