Comparing query outputs

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to select records from the output of one query that are not in the
output of another query. (Access 2003)
 
Hi Theresa,

make a new query

put both queries on the design screen

right-clik on your relationship line (do each one if it is a multi-field
join)

choose Join Properties

show All records from the main one and just those records from the other
where the fields match

on your grid, put the primary key of the second query (or something you
know will alwyas be filled out)

in the criteria cell --> Is Null

Warm Regards,
Crystal
*
(: have an awesome day :)
*
MVP Access
Remote Programming and Training
strive4peace2006 at yahoo.com
*
 
You must log in or register to reply here.

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

Report output appears to be in Chinese 1
Voltage supply issue related to NUC PC Core i7 0
IPhone sound quality gets worse each generation 5
Access 2003 db's & problems exporting query to Excel 1
2007 version query problems 1
Output query to excel 1
Access 2007 & Vbs Output Restrictions 9
Filter within a report 4

Back
Top