S
SusanJane sjl
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.
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.