Empty Cells

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
 
A

Allen Browne

To accept nulls but exclude records starting with "bbb", set the query
Critieria to:
Is Null OR Not Like "bbb*"
 
J

Joe Fallon

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.
 
Top