[AccessD] An Interesting question

Drew,

You're wrong.  Null is the absence of a value, indeterminate, not a
selection.  The absence of a value means nothing has been selected, not
that the user has selected a nothing, which is impossible.  The user can
elect to remove an existing value, but that doesn't make the resultant
null a value!  You can't compare anything to Null and the only test you
can make is Is Null.

Charlotte Foust

 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Drew Wutka
Sent: Sunday, March 29, 2009 4:03 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] An Interesting question

So black isn't a color? ;)

The absence of a value is still a value... ;)

Is this going to be another great debate?

Drew

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Stuart
McLachlan
Sent: Sunday, March 29, 2009 4:47 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] An Interesting question

No :-)
Null is NOT a value - it is something unknown. 

--
Stuart