Records not in related tables

M

MBraybrook

I would like to create a query to pull out records that do not have a record
in a related table, could anyone assist me on this?
 
A

Allen Browne

When you create a new query, one of the options Access offers is called:
Unmatched Query Wizard.

Put him to work.
 
M

MBraybrook

Allen,

I hoped it would be something simple, didn't realise it would be quite so
simple. I've always refused to use the wizards, I feel its time I changed my
mind!

Thanks for your assistance.

MBraybrook
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to have two tables on same line? 1
Adding data to MS Access from csv file 0
Trying to create a report that will list unmatched records by Ticket Primary Key 0
DLookup in Continuous form 0
Counting the sum of related records for a primary record 4
Duplicate Mail Merge Record Every Time 5
Mail Merge skipping records/sending one at a time 0
A problem occurred running while microsoft access was communicating with OLE server or ActiveX Control. 0

Top