[AccessD] NOT Query.

Well Arthur, in a nutshell, it has to do with initialization, which confuses 
the hell out of me, even though I'm supposed to be smart enough to "get" it. 
In a practical sense, null is an unused field -- never held a value and 
empty is a field that's stored a value, but that value has been deleted.

Now, someone much smarter than me is going to explain it properly, I hope.

Susan H.




> This is a concept that was way beyond me, going back as far as it goes. 
> Over
> here we have the "never allow NULLs" camp. Over there we have the "Allow
> empty fields" camp. I do not comprehend the purpose of the latter. Perhaps
> some astute lister could educate me on this matter.