Sorry if this is a stupid question, but I'd like to use the "Enter Parameter Value" capability in a query and report (where for example you put in [name] in criteria of a query) and then when you run the query it prompts for a name in the "Enter Parameter Value" box.
The problem I'm having is I don't know how to set it up so you can enter more than one name, like if you want it to search for "John" or "Steve" or "Amy"....... The Enter Parameter Value box only allows for one name.
Try this in criteria:
[name1] Or [name2] Or [name3]
I tried that, it doesn't work. It still asks for just 1 name.
Additionally, I need the Parameter to dynamic, so there's no set number of names that need to be entered. So that the user can put in as many as he/she wants.