Running a Report From A Crosstab Query

[Kennon]

I am trying to run a report from a crosstab query and keep coming up
with the error: The Microsoft Jet database engine does not recognize "
as a valid field name or expression

Here is the SQL for my query

PARAMETERS [Forms]![Report Form].[txtStart] DateTime, [Forms]![Report
Form].[txtEnd] DateTime;
TRANSFORM Sum(PRODUCTION_MK021P.MKPMVC) AS SumOfMKPMVC
SELECT [Week Ending].[Week Ending], Program.[Big Program], [Market
Sources].[Market Source]
FROM ([Week Ending] INNER JOIN ([Market Sources] INNER JOIN
PRODUCTION_MK021P ON [Market Sources].MKBSRC =
PRODUCTION_MK021P.MKBSRC) ON ([Week Ending].MKDRCN =
PRODUCTION_MK021P.MKENCN) AND ([Week Ending].MKDRDD =
PRODUCTION_MK021P.MKENDD) AND ([Week Ending].MKDRMM =
PRODUCTION_MK021P.MKENMM) AND ([Week Ending].MKDRYY =
PRODUCTION_MK021P.MKENYY)) INNER JOIN Program ON
PRODUCTION_MK021P.MKTCPG = Program.[Campaign Codes]
WHERE ((([Week Ending].[Week Ending]) Between [Forms]![Report
Form].[txtStart] And [Forms]![Report Form].[txtEnd]))
GROUP BY [Week Ending].[Week Ending], Program.[Big Program], [Market
Sources].[Market Source]
PIVOT PRODUCTION_MK021P.MKTRST;

 

[Duane Hookom]

Does the crosstab create the error or is this from the report?