Access

  • Thread starter Thread starter Robert
  • Start date Start date
R

Robert

Keep getting the message while in query "invalid use of
null". What does that mean?
 
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!
 
You must log in or register to reply here.

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

Dlookup in query - any pointers? 1
Multiple Parameter Crosstab query filter by form 1
#error - Blank 3
Check if a value is legal 2
how to correct Invalid use of null query 1
Union Query - Invalid use of null 1
Special Characters in Access 2007 2
Access 2003 - "Invalid Argument" error message 1

Back
Top