| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
parameter has multiple values seperated by value
my MSquery
select * from products where productname in ('printers', 'fax', 'chairs') My product names are a range of cells in a worksheet. The list of product names I want is a dynamic or user-entered list and can be 2 or 3 or upto 40 names. Can the msquery be parameterized ? I do not want to go for SQL.REQUEST or programming in VBA. Can any one has any hints ? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Parameter Query to return multiple values | Excel Discussion (Misc queries) | |||
| List cell values seperated by comma if criteria met | Excel Worksheet Functions | |||
| Find the sum of Comma Seperated Values In a Cell | Excel Worksheet Functions | |||
| Sum of comma seperated values in cell(Reposting) | Excel Worksheet Functions | |||
| column values to a cell with comma seperated | Excel Worksheet Functions | |||
Linear Mode
