Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
MS Query using Parameter in In() statement
I have a query in MS query with three parameters.
One of the parameters needs to allow the user to type in one or multiple possibilities, or leave it blank for all. I was planning to use the In() statement: In([Enter Codes here])... which works if I only enter one code, but not if I enter code,code. How can I create a parameter in MS Query that allows for the following situations? All Values A list of values One value. (Note: this is directly used in the Query, not in VBA) Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Parameter query in MS Query from Excel | Excel Discussion (Misc queries) | |||
parameter query | Excel Discussion (Misc queries) | |||
Convert hard coded query criteria to Parameter Query | Excel Discussion (Misc queries) | |||
How to choose if I use a parameter or not in a parameter query | Excel Discussion (Misc queries) | |||
How to use a Access Query that as a parameter into Excel database query | Excel Discussion (Misc queries) |