Ok, so here's the situation:
I have a table (ProgramReg) listing of 2000+ people who have enrolled in a program. This program has two categories, one of which requires a current first aid certification. Table ProgramReg contains the following fields: "First_Name", "Last_Business_Name", and "ProgID" (which identifies which category they are enrolled in: either 1101 or 1102).
I have another table (CurrentCert) of clients with current first aid certifications. The fields in that table are: "FirstName", "LastName" and the location at which they certified. The certification is offered once a year, and is valid for 4 years so the CurrentCert table changes once yearly.
What I want to do is run a query that will show me all people enrolled in the 1101 category (that's the one that requires certification) who do not appear in the CurrentCert table.
I have already created composite keys on each table using first and last names (the only thing the two tables have in common).
How do I create a query that lists only the records from ProgramReg where field ProgID = 1101, but which do NOT have a record that matches (both their first and last names) on the CurrentCert table?
Any help is greatly appreciated...I'm going cross-eyed from thinking about this!