Empty Cells

[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

 

[Allen Browne]

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

 

[Paul S]

Try adding 'Or is Null' to the expression

 

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