ACCESS AND TABLES

How set query to compare records on two table in Access?

On Wed, 12 Jan 2005 20:49:04 -0800, "GG"
wrote:

How set query to compare records on two table in Access?

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
on both tables?



"John Vinson" wrote:

On Wed, 12 Jan 2005 20:49:04 -0800, "GG"
wrote:

How set query to compare records on two table in Access?

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]

On Thu, 13 Jan 2005 09:27:05 -0800, "GG"
wrote:

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?

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]