Good morning experts,
I have 2 tables (tblClients and tblJobs)
The relationship is One Client to MANY Jobs via [Client ID]
I wish to have a query that reports Clients with no jobs.
I have tried several things similar to:
Select [Client ID] from tblClients Where Dcount([Client ID], tblJobs) = 0;
but that seems not to work.
Can someone give me a clue please to how I could do this.