| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
SQL parameter query - more than cell value
Sarah
Just add the operator to your parameter query in MSQuery [TheValueINeed] -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England HIS www.nickhodge.co.uk "SarahS" wrote in message ... I have created a parameter query in Excel which returns data from an sql database. The parameter is based on a cell value. Rather than return records equal to the cell value, I would like to return those which are greater than the cell value. I have tried everything I can think of but no luck so far. Any ideas please? Thanks Sarah |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Query SQL server db with cell value parameter | Excel Discussion (Misc queries) | |||
| Parameter query troubleshooting: Empty cell issue | Excel Discussion (Misc queries) | |||
| Parameter Query Cell substitution | Excel Discussion (Misc queries) | |||
| Microsft Query: Excel, date parameter cell doesn't work. | Excel Discussion (Misc queries) | |||
| Cell value as parameter for VBA access query | Excel Programming | |||
Threaded Mode
