Select Empty cells

[Hugues]

Hey guys,

it may seems straightforward, but how can I select empty cells when I am running a query?

Thanks

Hugues

 

[John Big Booty]

Try using Is Null as your Criteria.

 

[Hugues]

Thanks for the answer, but I realize now I haven't been specific enough. I run my query through a form where I can enter in text boxes the criteria I want to use for each category, I tried " " to select empty cells but it didn't work, any other idea?

 

[John Big Booty]

If you are using text boxes as Criteria, then try the following in your Criteria;

IIF (IsNull(Froms!FRM_Name!TextName),Like "*", Froms!FRM_Name!TextName)

Just insert your Form Name for FRM_Name and your Text box name for TextName.

If your Text box holds a null value then the Like "*" criteria will select all data in that field.