I am extracting data from an access 2003 database by date. I have built a query in the oledb editor. If I hardcode the date, the query work as such
SELECT t_PlanActuals.pa_Date, t_PlanActuals.pa_Day, t_PlanActuals.pa_DailyPlanParkers, t_PlanActuals.pa_DailyPlanMovers
I have defined a user variable called sweepdate but I cannot get the access syntax to accept it in the query string.
Can anybody tell me the correct way of passing the syntax? I tried using ? but that did not work when I tried the preview
View Complete Post