Link to home
Create AccountLog in
Avatar of Pdeters
Pdeters

asked on

Query to compare two fields - Access 2003

I have an Acess 2003 table
I hve a total of 10 fields. I want to tkae two fields and match them up to another table with the same fields - if one field matches and the second field does not  - show that record in the query
ASKER CERTIFIED SOLUTION
Avatar of kuintencst
kuintencst

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
SOLUTION
Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of Pdeters
Pdeters

ASKER

I am doing a comparison
This is what I am looing for

If table1.field1 is equial to table2.field1 then if
If table1field2 is not equal to table2.field2 feild show the records