Access

  • Thread starter Thread starter Robert
  • Start date Start date
You must have some expression like Len() in your query
that will not work when it is used against an empty field.
Can you copy/paste the SQL version of your query in your
question so we can see it?
-Cameron Sutherland
 
Keep getting the message while in query "invalid use of
null". What does that mean?
Click to expand...

It means that you are using a NULL - empty - field in a way which
Access cannot recognize or handle.

If you have problems with a query, bear in mind - WE CANNOT SEE YOUR
QUERY unless you post it. Open the Query in SQL view and copy and
paste the SQL text to a message here. Then maybe someone can diagnose
what's wrong. We can't as it is!
 
Back
Top