asked on How to compare two tables in access and filter by two criteria
HI. I am building an employee database. I have two subforms on the employee form in a tab control. There is a Certification Required subform and a Certifications Held subform. I need to compare the certs required to the certs held and return a list of missing or expired certifications. I can put that in another subform/tab or as a report. I need to filter the results by employee ID and also by Position ID. Certs required varies by Position ID. Can this be done in a query?
I have attached my database in progress. It isn't pretty yet but the basic function should be clear. Thanks!
Test1.accdb
I have attached my database in progress. It isn't pretty yet but the basic function should be clear. Thanks!
Test1.accdb
Microsoft AccessDatabases
Last Comment
esbyrt
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
When you are unfamiliar with SQL, it is easiest to use the QBE. Your query is missing the * in the select clause.
it also have an unnecessary comma before the word "Left"
Select FROM tblCertsRequired, Left
Select FROM tblCertsRequired, Left
ASKER
Thanks so much! That did the trick.
Select FROM tblCertsRequired, Left Join tblCertHeld on tblCertsRequired.CertID = tblCertHeld.CertIDNum
Where tblCertHeld.CertIDNum Is Null or tblCertHeld.ExpiryDate <= Date()