Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Parameter query conversion error on date
I have a pivot table that uses a MS Query to retrieve data. I have the
StatusDate criteria value as =[Begin Date]. When the popup comes up asking for the date, I enter in 9/1/08 or 9/1/2008 or 9-1-08 or and I get an msg "Conversion Error". If I key into the criteria value =9/1/08 it works just fine. BUT I need to use a parameter so the user doesn't have to edit the query every time it's run. -- Always grateful for help!! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Convert hard coded query criteria to Parameter Query | Excel Discussion (Misc queries) | |||
Pass date parameter into MS Query | Excel Discussion (Misc queries) | |||
How to choose if I use a parameter or not in a parameter query | Excel Discussion (Misc queries) | |||
Microsft Query: Excel, date parameter cell doesn't work. | Excel Discussion (Misc queries) | |||
MS Query Enetreing a date as Parameter | Excel Discussion (Misc queries) |