Finding matches between two TABLES

[DAbbot]

I have two tables inside the same db.



Both tables have a field named "ACCOUNT NUMBER"

I need to determine the records that match between the tables.

Thanks.

[ItsMe]

Have you tried building a query? I would give the Query Wizard a try.

[DAbbot]

Well, that's my problem.

In Query Wizard, I can build a "Find Duplicates" query from ONE Table, or a "Find Unmatched" from TWO Tables.

I need a to find matches between two tables.

[ItsMe]

This is usually done by creating a JOIN. If you use the query designer to create a new query object, you can add your two tables to the design surface. Create a join by dragging the name of one field from within one of the tables to a field name (could be the same field name as the first) in the other table. After you create your JOIN, you can double click the line that represents your JOIN to adjust its properties. I usually select the join with a single click before attempting a double click.

[orange]

DAbbot,

You should adopt/use a naming convention that does not use embedded spaces or special characters in field and object names. Use only alphabetic and underscore "_" characters. It will save you many syntax errors.

As ItsMe said a Join or INNER JOIN is what you need.

Good luck.