I don't use Access much and need a little help with a query.
I have a Clients query with a list of IDs (identifying the client) and a Report query with a list of IDs (same ID# as client ID, and there may be some IDs that are listed several times).
I want to see which Clients IDs are not in the Report IDs.
Here is my failure:
SELECT Clients.ID WHERE Clients.ID NOT IN Report.ID;
Thanks for any help.
I have a Clients query with a list of IDs (identifying the client) and a Report query with a list of IDs (same ID# as client ID, and there may be some IDs that are listed several times).
I want to see which Clients IDs are not in the Report IDs.
Here is my failure:
SELECT Clients.ID WHERE Clients.ID NOT IN Report.ID;
Thanks for any help.