Query link NOT in other Table - Microsoft Access Forum


	Back to Access Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Query link NOT in other Table

Sami Shamma

2 years ago

Friends

Is there an easy way to create a query that will return all the record from Table CustomerT only if the CustomerID DOES NOT exist on Table CutomerRegestedT.

I want to send a letter to all customers who has not yet registered.(do not have a record in (CutomerRegestedT)

Many Thanks

	Kevin Robertson @Reply 2 years ago
Use Is Null for the CustomerID from CustomerRegestedT. My example below will show only customers with no contact record.

	Kevin Robertson @Reply 2 years ago

	Kevin Robertson @Reply 2 years ago
There is also the Find Unmatched Query Wizard.

	Sami Shamma OP @Reply 2 years ago
Thank you Kevin. I am trying it now.

	Sami Shamma OP @Reply 2 years ago
Not that I had any doubts, it worked like a charm. Thanks again.

	Richard Rost @Reply 2 years ago
Yeah... What he said. 😁

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.

Next Unseen

New Feature: Comment Live View