By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,576 Members | 1,462 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,576 IT Pros & Developers. It's quick & easy.

Query looking for "not nulls"

P: 2
Hi,

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 ?
Thanx...
Sep 26 '06 #1
Share this Question
Share on Google+
4 Replies


P: 4
Have you tried using the Nz function.
Sep 26 '06 #2

P: 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

PEB
Expert 100+
P: 1,418
PEB
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

PEB
Expert 100+
P: 1,418
PEB
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.