G
GG
How set query to compare records on two table in Access?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
J
John Vinson
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]
G
GG
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
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
J
John Vinson
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]