one report with multiple criteria options

[mixedguy]

Need some help...

I have a report where the underlying query criteria is reading from four combo boxes. As of now the report runs based on what you pick in the combo boxes. I need an option where if the users select "ALL" in one of the combo boxes that it'll query based on three combo boxes and for the one where it's "ALL" give them everything for that criteria.

I hope you understand my Q.
Thanks in advance!

 

[llkhoutx]

You need to build a SQL string query based on your combo boxes, as appropriate, and store that result in a query. Use that query as the recordsource for your report.