Matched Query

K

KKash

Hi! I'm attempting to do a "matched" Query instead of an unmatched. I want
Access to compare two tables of data that I have and tell me which records
are the same. Anyone have any ideas? Thanks!
 
K

KARL DEWEY

In query design view put both tables in the space above the grid. Click on
field in one table and drag to the matching field in the other. Join as many
field as you are wanting to match. Put the field you want to display in the
FIELD row of the grid. Select Ascending or Descending in the Sort row for
those that you want the display order arranged.
 
K

KKash

That worked Perfectly! Thanks!

KARL DEWEY said:
In query design view put both tables in the space above the grid. Click on
field in one table and drag to the matching field in the other. Join as many
field as you are wanting to match. Put the field you want to display in the
FIELD row of the grid. Select Ascending or Descending in the Sort row for
those that you want the display order arranged.
Click to expand...
 

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

Comparing two tables in Access to look for discrepancies 0
Unmatched query question 3
Auto fill data to query results 2
Query quandry 1
Help! Unmatched Data Query 1
Exact match query 4
Comparing data between two tables 3
Finding and naming duplicates 4

Top