Query Questions

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
What does it do if you simply omit the criteria for that field? Try posting
the entire SQL statement from your query for analysis.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Back
Top