Proper query to check two different fields of a table

[bknight]

How should I create a query that checks two field values?
In other words where [field 1] <> [field 2] ?

[HansV]

In the Criteria row of Field1, enter

<>[Field2]

(or vice versa)

[bknight]

Um ok there were a few, however can you explain these leftovers?

[HansV]

I'd have to see the original data.

[bknight]

Too big, but I can include all of the fields in an Excel sheet if that would help.

[HansV]

No, copying into Excel might alter the data.
If you wish, you can send the database to me (hans dot vogelaar at gmail dot com).
I will treat the data confidentially.

[HansV]

bknight sent me the database, but since the problematic data had already been removed, there was no way to find the cause of the problem.