I have a query that i am trying to obtain specific data so i created a parameter so when the query is ran, it asks for an input. I understand how to do this, but is it possible to have multiple parameters for one field.
For instance, i have a field called region and the data options are R01, R02 all the way to R11. I want to be able to retrieve data for multiple regions, but i don't know how to do this on the design view. I thought i could just do [Enter Region] several times within the design field, but it doesn't work.
I have attached a screen shot of what i have in the design field. I event tried using the between option as i have done with dates(Between [Start] And [End]), but that didn't work either. it just came up with blank data.
Also, is there a way to make that prompt a drop down field so the individual can select versus manually typing in the data in case they didn't know what the field options were. I realize this would not be able to pull multiple regions.
Let me know if you have any questions or if you need a sample database.