Query Value Not Required

[BusDriver3]

Hello There,



I am trying to create a "Form" that contains several Combo-Boxes that will act as the criteria to feed a query. In the query I am using the following criteria for the Form values to feed the query

[Forms]![Report Generator 2]![Directorate]

This works when I select the values for each and every Combo-Box... But...

What I would like to do is make some of the Combo-Box values "Not Required" and still have the query work... Is this possible?

[CJ_London]

your query needs to account for a null so something like

[Forms]![Report Generator 2]![Directorate] OR [Forms]![Report Generator 2]![Directorate] IS NULL

[ItsMe]

Wouldn't an Nz() function or IIf and IsNull() help to provide the appropriate data type to the parameter?

[CJ_London]

alternatives could be

WHERE myfield=nz([Forms]![Report Generator 2]![Directorate],myfield)

or

WHERE myfield=iif(isnull([Forms]![Report Generator 2]![Directorate]),myfield,[Forms]![Report Generator 2]![Directorate])

or

WHERE myfield=iif([Forms]![Report Generator 2]![Directorate] is null,myfield,[Forms]![Report Generator 2]![Directorate])

Not tested on a large dataset but all involve using one or more functions which will generally slow the performance of the query

[ItsMe]

OK, I am starting to imagine how #2 could be applied.

[BusDriver3]

Thanks for the speedy responses! This forum is GREAT! I didn't have much luck with the examples above, but you guys made me rethink my objectives... I am going to use just three Combo-Boxes that are the most relevant to feed a report that contains the other ancillary details. Again thanks!