Unmatched

I

Ivor Williams

In Access there is a wizard called "Find Unmatched Query Wizard" which
compares two tables to determine if one contains data not contained in the
other. Is there a way to do this "en masse", that is to compare the data in
all the tables in one database with all the tables in another database?

Ivor
 
R

Rick B

I believe the purpose of that query is to find records missing from related
tables. I can't think of a case where you'd want to compare "all tables" in
one database to "all tables" in another database, and how would Access know
which tables should match. If you have 20 tables in each database, which
ones would be matched up by the query? I don't get it.
 

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

Find unmatched query with selected date 2
Help! Unmatched Data Query 1
Compare data that do not exactly match 3
Matched Query 2
Joins in unmatched query 2
Query-finding umatched data with duplicates 5
Query automatically changing my source table 3
Query comparing two fields in a table gives wrong results-why? 3

Top