Access

[Robert]

Keep getting the message while in query "invalid use of
null". What does that mean?

 

[Cameron Sutherland]

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

 

[John Vinson]

Keep getting the message while in query "invalid use of
null". What does that mean?

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!