Data type mismatch in criteria expression (Acc'97 query)
Posted on 2004-11-12
I've query in Access 97 where one field is calculated from text field in linked text file using function which converts text field to double format.
Query runs fine (and gives ~33000 records).
But if I set criteria (e.g. >0) to filter by this field - I get error message "Data type mismatch in criteria expression" after some rows are shown on screen.
If I change criteria expression from >0 to >"0" - I get the same error message imediatelly without any rows retrieved.
I've sorted my query by this field and in first rows I see some negative numbers like -5, then some rows with 0 and in last rows - positive numbers like 23510. So it seems that there are no "non-numeric" data in this column. But still I can't enter any criteria. Even if I enter the same field name or "Is Null" as criteria, I get this error message.
P.S. I've tried to compact and repair my database, but nothing helps...
p.p.s. sorry, only 125 points available... :(