Ignore Blank Query Criteria – Access 2010

[Jackson1942]

I have a main table that has relationships with seven other tables.
I have a Query that runs correctly based upon the main table and the other seven tables.
I have a Form that contains a Combo box based upon the four of the other tables. There is also a Command button to run a Query.

From the Form, if I select the Command Button without selecting any information from the Combo Boxes, I get a list of everything in the main table.

If I select items from all four of the Combo boxes, the Query returns the correct information.

If I leave any of the Combo selections out, the Query returns blank.

My Query Criteria for each of the fields is:

[Forms]![Form1]![Combo0]
[Forms]![Form1]![Combo6]
[Forms]![Form1]![Combo11]
[Forms]![Form1]![Combo9]

For each of the above, an “Exprn: Is Null” field was added to the Query.

I have tried numerous suggestions after searching the Web, Access Help and everywhere else to find out how to Ignore Criteria fields that are Null, Blank or without a selection.

After two days I’m asking for help, what am I missing?

 

[MStef]

Try to do that with LIKE in the query criteria.

 

[Jackson1942]

Thank You, it worked.

 

[atianhoun]

Want to use multi criteria with acess 2010. When a field is blank, it return no data while I want the query ignore blank fiels.
Please help.