Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Parameter Query Refresh issue
Hi there,
I am using Excel 2007 to return data from my SQL database via MS Query. Once the data is in Excel I am using a parameter query to filter out certain fields, for example, I filter on my Customer Code field. I have the parameter query set up and I am getting the parameter value from a cell on the spreadsheet, which the user can enter dynamically. If they want to view orders for customer 1005, they enter 1005 and these filter nicely. However, I cannot now show ALL the orders again AFTER this parameter has been applied. I have tried wildcards in the cell, but obviously a * is not in my Customer Code field, therefore no data is returned. I have also tried emptying the cell, using backspace and delete, but these do not work either. What is Excel waiting for that would allow it to return ALL the customer orders as it did in the first place before I applied a parameter?!?! Thanks in advance. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 data query parameter issue | Excel Programming | |||
Parameter query troubleshooting: Empty cell issue | Excel Discussion (Misc queries) | |||
How to choose if I use a parameter or not in a parameter query | Excel Discussion (Misc queries) | |||
Query parameter "refresh when value changes" doesn't refresh - why | Excel Discussion (Misc queries) | |||
automate query parameter refresh and multiple chart print out | Excel Programming |