Converted Access DB from 2003 to 2010 query not working 1

[Dom606]

I just converted an Access 2003 database to 2010. All the queries work but one. the error is data mismatch in criteria expression.

below is the sql for the query and I have no idea what is wrong. Suggestions?

TRANSFORM Sum([Time Card Hours].BillableHours) AS SumOfBillableHours
SELECT [Time Card Hours].DateWorked, Sum([Time Card Hours].BillableHours) AS [Total Of BillableHours]
FROM Projects INNER JOIN [Time Card Hours] ON Projects.ProjectID = [Time Card Hours].ProjectID
WHERE (((DateAdd("d",7-Weekday([DateWorked]),[DateWorked]))="3/12/2011"))
GROUP BY [Time Card Hours].DateWorked, [Time Card Hours].TimeCardDetailID, DateAdd("d",7-Weekday([DateWorked]),[DateWorked])
ORDER BY [Time Card Hours].DateWorked
PIVOT Projects.ProjectName;

 

[PHV]

I'd replace this:
WHERE (((DateAdd("d",7-Weekday([DateWorked]),[DateWorked]))="3/12/2011"))
with this:
WHERE (((DateAdd("d",7-Weekday([DateWorked]),[DateWorked]))=[!]#2011-12-03#[/!]))

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[Dom606]

That worked. Thank you