"invalid use of null" error in query w/multiple joins

S

Sasha

I have a query which joins 4 queries together.
Each query runs by iteself just fine.
I retested the main query each time I added another link.
When I added the fourth link, I suddenly get the
error "Invalid use of Null."

I can't figure out WHAT Access is saying is null.
I tried typing a procedure to open the query as a
recordset and print, one record at a time, in the
immediate window hoping I could find the problem that way.
no luck, it couldn't even open the recordset.

The joins are on one field only, and none of the tables
show any null values in that field.

I am doing an outer join from one query to the other three
but i've never gotten this error from that before.

Any ideas?
thanks,

Sasha
 

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

"Invalid use of Null" in query 3
Ambiguous outer join 6
Invalid use of Null 4
Problem with outer join - Invalid operation (Error 3219) !? 2
Inner join with some null values 9
Invalid use of null 3
Join on a UNION query 2
Having trouble with Outer Join 1

Top