report based on criteria

[pirsein]

I currently have a report that is based on query selection. But now I have added another field(that's based on a combo), this field hasn't been used yet. So a form comes up w/ combo boxes to select what they want to see on a report. The problem is, if the field has no data in it then it will not display anything. Or even if that field has data in 5 tests and there are 100 tests then only the 5 will show. Here is my logic for the query criteria and this is for each field that I have(there are 6 fields)

Like "*" & [Forms]![ReportDialog]![PlasticGauge] Or Like "*" & [Forms]![ReportDialog]![PlasticGauge]

What do I need to do to get it overlook that there is no data in the field and just select what I have chosen from the cbo boxes?

Thanks.

 

[ThreeCrow]

Try this

Like Iif(IsNull([Forms]![ReportDialog]![PlasticGauge]),"*", [Forms]![ReportDialog]![PlasticGauge]