Matched Query

  • Thread starter Thread starter KKash
  • Start date Start date
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!
 
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.
 
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...
 
Back
Top