Using IN expression with a parameter to filter queries

C

Chuck

I am attempting to use the IN expression along with a parameter to filter a
query. I am using the criteria seciton of the criteria grid. Example: IN
([Enter shift in the following format: 1,3,5,8]). Is this not possible?
 
D

Duane Hookom

This will not work as you would like it to.

IMO, parameter queries aren't appropriate user interface. You are better off
using a multi-select list box on a form. This almost always requires some
coding (there are lots of examples on the web).
 
C

Chuck

Thank you Duane!

Duane Hookom said:
This will not work as you would like it to.

IMO, parameter queries aren't appropriate user interface. You are better off
using a multi-select list box on a form. This almost always requires some
coding (there are lots of examples on the web).

--
Duane Hookom
Microsoft Access MVP


Chuck said:
I am attempting to use the IN expression along with a parameter to filter a
query. I am using the criteria seciton of the criteria grid. Example: IN
([Enter shift in the following format: 1,3,5,8]). Is this not possible?
Click to expand...
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Multiple Parameter Crosstab query filter by form 1
Use In() Expression as Query criteria with guts from Function 1
Parameter Value in Crosstab Query 4
parameter with iif statement in query criteria 8
Parameter Query? 10
Duplicate Invoice Query 1
Parameter Query to filter dates as entered in and if not to show N 4
Parameter Queries in Crosstab Query 2

Top