469,601 Members | 2,039 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,601 developers. It's quick & easy.

Query looking for "not nulls"


I am trying to run a query which whill pull the data from fields if the are "not empty" however what happens is if any of the records are empty then it does not show that record.

I have tried setting each text field criteria to "not null" but this doesn't pull anything out because all of the records are missing a few of these text fields.

Any ideas ?
Sep 26 '06 #1
4 1430
Have you tried using the Nz function.
Sep 26 '06 #2
Hi - I don't believe this will work - although I may be doing this the wrong way anyway...

I am trying to produce a query which will return all fields within a record that have a value.. I do not want to produce any fields which have NOT been filled in.

When I do it, it checks all fields belonging to one record and if any of them do not satisfy these conditions then it fails...

So, what I want is if - one field does have the criteria then fine, it checks then next one etc...

I think I am confusing myself now...!"
Sep 26 '06 #3
1,418 Expert 1GB
IF U use nz function when your field is null it is converted to zero value = 0
So inside not / to search for nulls U nedd to do it for 0!
Sep 26 '06 #4
1,418 Expert 1GB
Do u have a join btween 2 or more tables on the concerned Null Fields? This can be the reason that those records doesn't appear!
Sep 26 '06 #5

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

9 posts views Thread by Susan Bricker | last post: by
3 posts views Thread by Chris Hayes | last post: by
5 posts views Thread by ano | last post: by
11 posts views Thread by Bruce Lawrence | last post: by
reply views Thread by suresh191 | last post: by
4 posts views Thread by guiromero | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.