can you enter multiple selections in a parameter prompt?

[ecalvert47462]

All, I am working in Access 2010....and I have a simple query that grabs just a few fields from a table and puts them in a reporty..they are:

Workcenter
Date Ordered
Date Shipped
Dollar Value

And there are 6 different workcenters that can be chosen, like: A, B, C, D, E, F.....and when the user presses the button to run the report then it prompts them to enter a Workcenter code...so they can enter A and then the query runs and returns all the stuff that workcenter A did....which that works great.

But what i want to do is group some of them together like if workcenter D, E and F needed to be pulled is it possible for the user to enter one character, for example if D, E and F were grouped together as maybe X...how would I make it to where the end user can enter X and it brings back results from D, E and F...instead of them running it 3 seperate times to get those results.

Thanks

[ItsMe]

I don't normally use parameterized queries. I imagine you could create an expression that would include multiple criteria for a single field by using the AND operator. The only problem is that you would have to hard code how the number of criteria. For instance, if the user only wants to include A, B ,and C one day and then include A,B,C, D, and E the next day, the parameterized query will not work.

I would use a list box. This would require VBA

[June7]

And here is the code http://allenbrowne.com/ser-50.html