Records not in query

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

Guest

Is it possible to show the records that aren't in a query?

I have a select query which runs fine and selects what I tell it to but then
I would like to know which records are not in the query. Is there a simple
way to do this?

Thanks.
 
Save the query you have.

Use the Unmatched Query Wizard to find the records that are in your table,
but are not in the saved query.
 
Perfect Allen.

Thank you.


Allen Browne said:
Save the query you have.

Use the Unmatched Query Wizard to find the records that are in your table,
but are not in the saved query.
Click to expand...
 
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

Combine Duplicates in Query 0
Delete Query: Could not delete from specified tables 0
loop though records in a query? 5
running total of records in query 1
Access 2010 append query to SQL is very slow 0
Basic Select Query Duplicating a single end user's records 2
Itereate cross tab query over another query 0
Parameter Query Won't Run 0

Back
Top