Using IN expression with a parameter to filter queries

  • Thread starter Thread starter Chuck
  • Start date Start date
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?
 
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).
 
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...
 
Back
Top