Home |
Search |
Today's Posts |
#1
|
|||
|
|||
parameter query - multiple options
I have a parametery query setup in excel which gets its input from a cell,
which does this.. Status In [EnterStatus] [EnterStatus] query is in a cell It works fine if I only enter one value in the cell but if I enter A,I,X (Active, Inactive, Expelled) for example i receive a string truncation error... if there were only two or 3 options I coult use 2 or 3 fields, but ehre are 10 possibles... any ideas how I can ask for multiple options.. the sql query would be Select * fom table where status in ('A','I','X')... aNY IDEAS |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Linking parameter query from Access to pivot table in Excel | Excel Discussion (Misc queries) | |||
How do i enable the Query Parameter menu option on the External D. | Excel Discussion (Misc queries) | |||
Parameter Query-enter just once for use in multiple places | Excel Discussion (Misc queries) | |||
Double-Clicking a cell for Multiple Options | Excel Discussion (Misc queries) | |||
How to use a Access Query that as a parameter into Excel database query | Excel Discussion (Misc queries) |