Hi,
I wasnt quite able to find an answer anywhere yet for what i am looking to do, so here it goes...
I have a parameter query set up to run a report which is simply asking for an employee id.
So in the query I have [Enter Employee ID] in the criteria section for the EmployeeID field.
When i run it it works fine if i put in a single number like 11, and i get Employee 11's results in my report.
However i cant figure how to put in more than one employee.
Example; if i put the following straight into the criteria for EmployeeID in the query, i get results from these four employees which is great.
11 Or 13 Or 14 Or 27
However if i leave it like i originally had it as a parameter [Enter Employee ID] and put in 11 Or 13 Or 14 Or 27 to the parameter, i get no results.
I tried quotes, semicolons, commas - i just cant get it to work with multiple criteria.
Can anyone help me?
Thank you,
Brian
I wasnt quite able to find an answer anywhere yet for what i am looking to do, so here it goes...
I have a parameter query set up to run a report which is simply asking for an employee id.
So in the query I have [Enter Employee ID] in the criteria section for the EmployeeID field.
When i run it it works fine if i put in a single number like 11, and i get Employee 11's results in my report.
However i cant figure how to put in more than one employee.
Example; if i put the following straight into the criteria for EmployeeID in the query, i get results from these four employees which is great.
11 Or 13 Or 14 Or 27
However if i leave it like i originally had it as a parameter [Enter Employee ID] and put in 11 Or 13 Or 14 Or 27 to the parameter, i get no results.
I tried quotes, semicolons, commas - i just cant get it to work with multiple criteria.
Can anyone help me?
Thank you,
Brian