Comparing data in one column to another column

rynorem

Registered User.
Local time
Today, 15:25
Joined
Jan 9, 2006
Messages
27
I have two separate columns in my query but they contain the same kind of data. These two columns data should match but some of the data doesn't. Can I write a criteria that will show me only the rows that do not match.

DUTY POSC
11B1 11B1
11B1 11B1
11C1 11B1
11B1 11B1
92Y1 11B1
11B1 11B1
13F1 21B1
For example, I want the query to show me only the rows in which the data in the Duty column doesn't match the POSC column.
 
In the POSC field's criteria type:
Code:
<>[DUTY]
Or the other way round...

Bobadopolis
 

Users who are viewing this thread

Back
Top Bottom