Complex error in Query

S

Stockwell43

Hello,

I have a query that retreives information from one table main table. The
query qorks fin as I have a date range for the Date Recieved field and a
Like* in the Status field and it works like a charm. The proble is my manager
whats the report to pull ONLY the records where the Original Docs Received
Date is blank (the field name is ELPRD). When I place IsNull or Is Null or
Null or =IsNull etc.. it keeps giving me an error the my expression is typed
incorrectly or is too complex to be evaluated. I only want it to do one
simple thing why do I keep getting this error?

Thanks!!
 
S

Stockwell43

I got it. For some reason access puts in quotes and the query didn't seem to
like it so I removed them and it works fine.

Sorry folks!
 

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

If Statement with "*" in Query 2
#error - Blank 3
Parameterised query to return all records or those Between two val 2
"Query is too complex" Problem 3
Filtering by Month 1
query too complex 3
ACCESS query expression that works on one computer but not another 4
Complex Criteria Parameter Query 2

Top