LOL. That looks very familiar...WHERE field1 is not null and field2 is not null and field3 is not null
Yes, that brings back records that have a value but I want to exclude those all from view if all three fields have a value.in your criteria grid put
is not null
on the same line for each field.
in sql view you should end up with something like
WHERE field1 is not null and field2 is not null and field3 is not null
So, you are saying you want the opposite result, correct?Yes, that brings back records that have a value but I want to exclude those all from view if all three fields have a value.
yesSo, you are saying you want the opposite result, correct?
Then try negating the expression. For example:
WHERE Not (Field1 Is Not Null AND Field2 Is Not Null AND Field3 Is Not Null)
Field: Field1 Is Not Null AND Field2 Is Not Null AND Field3 Is Not Null
Criteria: False
WHERE ( ( Not (Field1 Is Null ) ) AND ( Not (Field2 Is Null ) ) AND ( Not (Field3 Is Null ) ) )
WHERE Not( (Field1 Is Null ) OR ( Field2 Is Null ) OR (Field3 Is Null) )
In a query, how can I exclude all records where field1, field2 and field3 are NOT null?
All three fields must have some value in it to be excluded.
Thanks
People say "all three" when they actually mean "each of the three"; just as they say "last" when they mean "most recent". That becomes the difference in our interpretations of the request.All three fields must have some value in it to be excluded.
AAAAAAAAAAAAA lol. It should take about 5 seconds of experimenting in design mode for her to get what she wants.As I read the request, and I admit I could be wrong since it is not even close to being precise, Instead of saying what she does want, she makes two negative statements. Not Null is a negative statement and exclude is a negative statement.
I think Kitty wants only rows were at least one column is not null.
People say "all three" when they actually mean "each of the three"; just as they say "last" when they mean "most recent". That becomes the difference in our interpretations of the request.
Does Kitty mean she wants records where ALL three fields are not null OR where at least ONE field is not null?
Hi. Have you tried any of the suggestions yet? Did none of them work for you? Just curious...This is what I'm looking for... Seems like it's still not clear. Sorry.
In my query, I don't want to see records that have ALL three fields with a value.
If ALL three have a value in those fields, I do not want that record returned.
All other combinations I want to see those records.