Filter for equation result

[gg80]

I have two numerical table sources that I identify as A and B (actual names are identical from the two sources). I would like to apply a query filter to not display records where A=B. I added an entry A-B and tried to filter it for <>0. Also tried IIF(A=b etc. The query happily displays 0 when not filtering, but when I try to filter for <>0 or 0, I get error message "Enter Parameter Value". Appreciate any help. Using Access 2007

[orange]

Show us some code and your tables.

[pbaldy]

This can happen when you filter on a calculated field, because of the order in which clauses are evaluated. Why not just put <>B in the criteria for A?

[gg80]

This can happen when you filter on a calculated field, because of the order in which clauses are evaluated. Why not just put <>B in the criteria for A?

Doesn't work. Access puts quotes around B (<> "B"), whether I want it or not. If change to [B] doesn't work either. I did find that if, in the calculated field, I changed A and B to NameOfTable.NameOfField-NameOfOtherTable.NameOfField and filtered for <>0, works. so can do it, but seems a little clumsy.

Thanks for quick reply.

[gg80]

Thanks for reply. Look at other input from pbaldy.

[pbaldy]

I suspect if you'd used the same syntax in the criteria, it would have worked. In SQL view:

WHERE NameOfTable.NameOfField <> NameOfOtherTable.NameOfField