Query with multiple null fields

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

The query i created has 3 fields that have criteria on them. I want the
query to return all results that do not have all three of those fields as
null. However when i put "Is Not Null" on the same line in all three fields,
it only returns results that do not contain any nulls at all. I would assume
the where statement to be similar to this: WHERE (([field1] = "Is Not Null")
AND ([field2] = "Is Not Null") AND ([field3] = "Is Not Null"))

Thank you for any help you can provide
 
In your query design, you would put Is Not Null on three separate
lines, one for each field. What this will do is change your where
clause to have OR instead of AND.

Hope that helps!
 
Thank you very much, works perfectly.

Jeff L said:
In your query design, you would put Is Not Null on three separate
lines, one for each field. What this will do is change your where
clause to have OR instead of AND.

Hope that helps!
The query i created has 3 fields that have criteria on them. I want the
query to return all results that do not have all three of those fields as
null. However when i put "Is Not Null" on the same line in all three fields,
it only returns results that do not contain any nulls at all. I would assume
the where statement to be similar to this: WHERE (([field1] = "Is Not Null")
AND ([field2] = "Is Not Null") AND ([field3] = "Is Not Null"))

Thank you for any help you can provide
Click to expand...
Click to expand...
 
Back
Top