Query Questions

M

Metalteck

I have a query that is part of an mde file. It has been running since
october. As of today, the query will not work and gives me an error message
indicating it has an invalid argument. I eliminated fields in the query till
I got to the one that would let me run the query. The criteria for the field
that I deleated is "is Null". If I change ti to >0, it will still tell me
that I have an invalid argument, but then runs the query. I've checked the
field in the tables option, but when I try to sort there, it also gives me an
invalid argument message. Is there a reason why this would start occurring,
and is there a way to fix this so it works the way it used to?
 
B

Brian

What does it do if you simply omit the criteria for that field? Try posting
the entire SQL statement from your query for analysis.
 
Top