Show only records in table A without matching records in table B

G

Guest

I have 2 tables with a one-to-many relationship. I would like to create a
query that shows only those records in the main table (the "one" part in the
relationship) that DO NOT have matching records in the other.

Thanks in advance,

Paulo
 
G

Guest

The best way will be using the query wizard to create an Unmatching records
query that will list all the records that are in one query but not in the
second table
 

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

Multiple Matching Records in Related Table 4
Query Not Displaying All Main Table Records 1
Exclusion Query- MS Access 2007 2
Select records from tble-A where no records in tbl-b meeting crit. 3
Using Table to Select Records from Larger Table with Join 2
Counting the sum of related records for a primary record 4
Find matching records based on two fields 2
Query showing all records from child table 5

Top