Finding Customers (table-1) without Tasks (table-2)

[fredfortsonsr]

I have longed used a qry to find customers (table-1) who have tasks assigned (table-2).

Now, as my customer base has grown, I want to find customers who may have fallen betwixt the cracks and no tasks are currently assigned. I think I have been working on this too long. I have tried every JOIN in the book but now I'm convinced that's not the answer.

So, are there any suggestions on how to find ALL records in table-1 that DO NOT have a "TaskPurpose" in table-2?

I know that I'm going to be embarrassed on how easy this could have been.

Thanks in advance!
Fred

[pbaldy]

Try 2 queries. The first returns all clients that DO have tasks, then use the unmatched query wizard to compare that query to the customer table.

[fredfortsonsr]

Paul, I want to thank you for the advice. I never had occasion to use that for of the query wizard. It worked like a charm and it will help me immeasurably in not losing contact with clients. I found 293 contacts that I need to communicate with and it's all because of you!

Keep doing the good work!
Fred - (big smile)

[pbaldy]

Happy to help Fred, and welcome to the site by the way!