Syntax error in TRANSFORM Statement

[pc13401]

getting error above, see query below. Please help.

TRANSFORM Sum([BIERS Combined IPAC].[Dollar Amount]) AS SumOfAmount
SELECT ([BIERS Combined IPAC].[IPAC document #])
FROM ([BIERS Combined IPAC] LEFT JOIN [IPAC 224 Classifications] ON [BIERS Combined IPAC].[IPAC document #] = [IPAC 224 Classifications].[IPAC #]);
WHERE ((([IPAC 224 Classifications].Classification ) Is Null))
GROUP BY [BIERS Combined IPAC].[IPAC Document #]
PIVOT [BIERS Combined IPAC].[Fund-FY];

[twinnyfo]

Usually a syntax error gives some sort of description. You can't possibly expect us to figure this out based upon what you have given us.

[Rabbit]

You have an extraneous semi-colon in the middle of the SQL