I really don't understand this and have never seen before. I want to confirm with you guys/gals I'm not nuts. I've attached a sample. Very simple table with a field called criteria. One of the three records has an X in it. This query, which in my mind should return 2 records returns 0.
SELECT Table1.test, Table1.criteria
If I change the query to the follow I can get the two records. (adding NZ)
SELECT Table1.test, nz([criteria]) AS Expr1
I've never seen this before. Do you guys see the same result for the first query? I don't understand how a blank or null field is not equal to X....