By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,491 Members | 1,169 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,491 IT Pros & Developers. It's quick & easy.

Syntax error in TRANSFORM Statement

P: 1
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];
2 Weeks Ago #1
Share this Question
Share on Google+
2 Replies


twinnyfo
Expert Mod 2.5K+
P: 3,054
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.
2 Weeks Ago #2

Rabbit
Expert Mod 10K+
P: 12,315
You have an extraneous semi-colon in the middle of the SQL
2 Weeks Ago #3

Post your reply

Sign in to post your reply or Sign up for a free account.