Hi,

I am new to Access and an hoping someone can point me in the right direction. I have two tables that are inner joined by FIELD_A. Both tables are have the same fields but the data comes from different sources. So I have Table 1 Field_A Field_B & Field_C and Table 2 Field_A Field_B & Field_C. The tables are joined by Field_A and my query output is:

Table1.Field_A Table1.Field_B Table1.Field_C Table2.Field_A Table2.Field_B Table2.Field_C

What I want to do is select records where Table1.Field_C is not equal to Table2.Field_C.

I have tried playing in the SQL view but I just can't seem to get it. Any advice?

Thanks

Access has a wizard to do this. Use the Query Design wizard and choose the Unmatched query wizard.