I need help with query criteria

[mrz via AccessMonster.com]

Hey all!

I have two tables that I need to compare. The data is coming from two diff.
systems but the data has the same meaning.

Table 1: with the following fields:

ID#, Gross Amount, Dept#, Obj Code, Pay Date, Source

Table 2: with the following fields:

ID#, Account#, Dept#, Source

I need to surface the records in both table in which the ID#s are the same
but the Dept number is different.

Kindly post your suggestions.

Greatly appreciated very much

 

[Guest]

Create a query with the two tables and open in design view. Click an drag
from the ID on one table to the other table ID.
Pull dow the fields you want to display - include the ID and the Dept# from
both tables.
Use this as criteria for Table2 Dept# --
<>[Table1].[Dept#]