Select all rows in a table that are different from another table?

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

Guest

I want to compare two tables and list out the rows that are in one table and
not in the other. Does anyone know how to do this?
 
mce said:
I want to compare two tables and list out the rows that are in one table and
not in the other. Does anyone know how to do this?
Click to expand...


The query wizard knows how ;-)

Seriously, just create a new query and select the wizard for
Find Unmatched Query.
 
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

VBA - retrieve data on last create named range from previous inserted named range 0
How to Populate Data from a table to another 0
Access Sorting and grouping using multiple tables 0
How to export table from outlook into ms access table? 0
How to auto fill different rows in the same table 1
How to populate a column in a row based on a value in another colu 3
Adding my own rows to a Union Query without adding another table? 3
i want to compare two tables and find duplicates 1

Back
Top