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.
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.