Daily Access Tips

Peter Vogel discusses Null Fields

I recall having numerous problems with this area until I got some help.  All Access developers who are not sure of the potential NULL problems and their solutions should read this article. It will save you several headaches!

Nulls give most database developers a lot of trouble. One example is that you can’t compare Nulls to anything and another is that a numeric field with Null in it won’t be less than, equal to, or greater than any other number. Yes Null fields are a difficult concept but you need to understand them to be a database expert.

Find the full article here.

Enjoy the articles,

Bob Heifler