function that would lookup for null value

function that would lookup for null value

Hi, I'm trying to find a way to look in a table for null value.
If there's a null value, then I would show a msg box, if not, I would
show another msg box.

I would prefer something like dlookup, dcount ...
I've tried rs.Find "TrackingNO = Null" but not sure how to integrate
it to a if (since it doesnt flag if it found a null or not, it merely
returns the row of the recordset.

thank you

date: Fri, 4 Jul 2008 10:57:21 -0700 (PDT) author: magickarle

Re: function that would lookup for null value

Null is a special case. Null means "unknown". You can't use boolean 
comparison operators with Null, since "unknown" could mean 2 in one case and 
"elephant" in another...

If all you want is to know whether there are any Null values in the table, 
you can using

DCount("*", "[NameOfTable]", "TrackingNO IS NULL")



-- 
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)


"magickarle"  wrote in message 
news:665ff3c2-3b47-487c-910f-4fc9c8bf2c3d@f63g2000hsf.googlegroups.com...
Hi, I'm trying to find a way to look in a table for null value.
If there's a null value, then I would show a msg box, if not, I would
show another msg box.

I would prefer something like dlookup, dcount ...
I've tried rs.Find "TrackingNO = Null" but not sure how to integrate
it to a if (since it doesnt flag if it found a null or not, it merely
returns the row of the recordset.

thank you

date: Fri, 4 Jul 2008 17:05:44 -0400 author: Douglas J. Steele

Re: function that would lookup for null value

On Jul 4, 5:05 pm, "Douglas J. Steele"
 wrote:
> Null is a special case. Null means "unknown". You can't use boolean
> comparison operators with Null, since "unknown" could mean 2 in one case and
> "elephant" in another...
>
> If all you want is to know whether there are any Null values in the table> you can using
>
> DCount("*", "[NameOfTable]", "TrackingNO IS NULL")
>
> --
> Doug Steele, Microsoft Access MVPhttp://I.Am/DougSteele
> (no private e-mails, please)
>
> "magickarle"  wrote in message
>
> news:665ff3c2-3b47-487c-910f-4fc9c8bf2c3d@f63g2000hsf.googlegroups.com...
> Hi, I'm trying to find a way to look in a table for null value.
> If there's a null value, then I would show a msg box, if not, I would
> show another msg box.
>
> I would prefer something like dlookup, dcount ...
> I've tried rs.Find "TrackingNO = Null" but not sure how to integrate
> it to a if (since it doesnt flag if it found a null or not, it merely
> returns the row of the recordset.
>
> thank you

Thank you. That did it!

date: Mon, 7 Jul 2008 06:05:26 -0700 (PDT) author: magickarle