How to use a list box to multi-select for a report

[homer2002]

I'm trying to create a report with a list box to select different
parameters for a report.

I've created a form with a list-box and the report works fine (after 4 years of re-formatting the report wizard's attempts )

however whenever I make the list box multi select
the report doesnt work


Can you use multi select on reports or is there another way to do this??

 

[glynch]

You may need to change the query that feeds the report. My guess is that the WHERE clause of that query is only set up to accept one value from the listbox. You would need to write the WHERE clause on-the-fly to accept any of the values from the listbox.

HTH