ACCESS AND TABLES

  • Thread starter Thread starter Guest
  • Start date Start date
How set query to compare records on two table in Access?
Click to expand...

By creating a Query joining the two tables on some appropriate field
and comparing them.

If you would like a clearer or more detailed answer, please post a
clearer or more detailed question, mentioning (for example) the nature
of the tables and the comparison that you wish to make.

John W. Vinson[MVP]
 
John,
I have 2 tables created in access:
Table one list customers with outstanding items and Table 2 have customers
that do not have outstanding items.

I want to run a query against the tables to see what account numbers appears
 
John,
I have 2 tables created in access:
Table one list customers with outstanding items and Table 2 have customers
that do not have outstanding items.

I want to run a query against the tables to see what account numbers appears
on both tables?
Click to expand...

Create a new Query. Add both tables to the Query. Join them by the
unique account number. Select whichever fields you want to see.

I would strongly suggest that you do some reading on database design.
Having two tables of customers like this IS VERY BAD DESIGN. It's
storing data (the existance or nonexistance of an outstanding item) in
a table name. That information should be determined instead by a
Query; I'm not sure what an "outstanding item" is or how that is
represented in your table, but you should have one and only one
Accounts table, and use a query joining it to a table of "items" to
determine who does and doesn't have any outstanding.

John W. Vinson[MVP]
 
Back
Top