[AccessD] An Interesting question

Woaa Charlotte, don't tell Drew he is wrong.  BAD move.  Now we have to listen to a dozen more 
emails on exactly why he is right.

;)

John W. Colby
www.ColbyConsulting.com


Charlotte Foust wrote:
> 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
>