Complex error in Query

  • Thread starter Thread starter Stockwell43
  • Start date Start date
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!!
 
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!
 
Back
Top