Matching Data

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have 2 tables that contain the same fields.

I would like to get data back where Field 1 in table 1 and 2 (Account #) are
are the same but in Field 2 ($ Balance) it is different.
 
1. Create a new query into these 2 tables.

2. In the upper pane of query design, drag Field1 from Table1, and drop it
on the matching field in Table2. Access shows a line joining the 2 tables.

3. Drag the 2nd field from both tables into the grid.
In the Critiera row under Balance from Table1, enter:
<> [Table2].[Balance]

The query now shows the matching fields (because of the joins at step 2)
where the balances are different (because of the criteria at step 3.)
 
Back
Top