I'm looking for a way to allow the end users to enter multiple criteria in a parameter in a query. In theory I thought this critieria would work, but instead it returns nothing.
Criteria value:
In ([Enter Item#(example: "D05494","IM5506")])
If I hard code the item numbers like this: In ("D05494","IM5506"). It work fine. I want the end user to make multiple selections without going into the design view of the query or have them enter the criteria in a separate table. Can anyone help ? It would be greatly appreciated
Criteria value:
In ([Enter Item#(example: "D05494","IM5506")])
If I hard code the item numbers like this: In ("D05494","IM5506"). It work fine. I want the end user to make multiple selections without going into the design view of the query or have them enter the criteria in a separate table. Can anyone help ? It would be greatly appreciated