Enter Multiple Values Into a Parameter 3

[Hillary]

I have a report which is based on a query and has a parameter [Enter Student ID].

Is it possible to set up the parameter so the user can enter multiple Student ID's? The ID's would not be consecutive.

Thanks,

Hillary

 

[dhookom]

You can create a new column in your query grid:
WhereAt: Instr([Enter Student IDs with comma between],[StudentID])
Then set the criteria to:
>0

However, I think parameter queries are generally a bad idea. I would recommend using a multiselect list box or other control on a form. You can find code in the Reports FAQ on using a multiselect list box for filtering a report.

Duane
MS Access MVP
Find out how to get great answers faq219-2884.