Unmatched Values

[s.booth]

I have a querry call AccountCheck and it contains 4 fields, 2 of which contain account numbers.

The fields containing the account numbers are called PSAcc and MKAcc

What I would like to do is only show the records where the values in the account number fields are unmatched in each record.

I have read some questions that are similar and thay seem to use the SELECT statement, could I please be enlightened to where these statements are entered in the querry and the correct syntax to use for the querry above.


Thanks

 

[Jon K]

In the query grid, put <>[MKAcc] in the Criteria for the PSAcc column.