Empty Cells

  • Thread starter Thread starter IanF
  • Start date Start date
I

IanF

Hi,

How can I prevent the following :

Running a query off a table. If you add criteria to a
column such as not like "bbb*", then as well as excluding
the above criteria, the query excludes any blank cells
from that column.

Cheers
Ian
 
To accept nulls but exclude records starting with "bbb", set the query
Critieria to:
Is Null OR Not Like "bbb*"
 
Don't leave them empty. <g>

Seriously, you can make an argument for assigning Default values instead of
Nulls.
I have done it that way for many years.
 
Back
Top