Query Criteria

[ccordner]

Sorry if this is a silly question.

I have two tables - tblVolunteers and tblContactMade.

tblContactMade lists each instance where I have made contact with a volunteer. I have set up a query, with fields from tblVolunteer and the ID field from tblContactMade.



How do I filter out just the records from tblVolunteers where there are no corresponding entries in tblContactMade?

Thanks
Chris

[Rawb]

Just use a standard Inner Join.

You can do this in the Query Builder by dragging the Field from tblVolunteers onto the Field you want to link it to in tblContactMade.

[ccordner]

Just use a standard Inner Join.

You can do this in the Query Builder by dragging the Field from tblVolunteers onto the Field you want to link it to in tblContactMade.

I'm not sure I understand.

In design view, I showed both tables. I linked the two, but the only options I could find are "All records in tbl Volunteers and only records from tblContactMade that match" or "All records from tblContactMade and only records from tblVolunteers that match".

What I actually want is "only records from tblVolunteers for which there are no matching records in tblContactMade".

I tried setting the criteria field for the [ID] in tblContactMade to ="", but that didn't work. I also tried setting Count([tblContactMade]![ID])=0, but that didn't work either.

Chris

[Rawb]

Sorry, I misunderstood what you wanted.

In that case, you will want to choose the option that says "All records in tblVolunteers and only records from tblContactMade that match." Then, you add a criteria for [tblContactMade].[ID] where it Is Null.

Like So!