Two tables for one query.

[BADebbie]

I have two tables. One has the name of the person, and the other table has the date of a training. When I bring the two queries together, I need to know who has NOT taken the training. My query does not show this, only the ones who have. What can I do to find out who hasn't?

[BADebbie]

Sorry. When I bring the two tables together in a query, they don't show who has not taken the training.

[alansidman]

What are the field names for each table. Have you tried using the Unmatched Query Wizard.

[BADebbie]

tblEE has EEID, LastName, FirstName
tbleLunches and Other Dates - Accident Training Date.

I have not tried that query. Mostly because I don't know what it is.
It might not be possible, but can't I just bring all the fields together and put in the date they took the Accident training?

[aytee111]

The unmatched query is produced by using the Query Wizard. It will ask for the two table names and which field you are using to link them together.

To do it yourself in query design, link the two tables, right-click on the join line and select the option for all tables from table 1 whether there is a matching value in table 2 or not. Then add a criteria of Is Null for the key field in table 2. This will give you all records in table 1 that don't have a matching record in table 2.