Matched Query

[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!

 

[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.

 

[KKash]

That worked Perfectly! Thanks!

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.