By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,347 Members | 2,091 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,347 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];
Mar 6 '19 #1
Share this Question
Share on Google+
2 Replies

Expert Mod 2.5K+
P: 3,284
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.
Mar 6 '19 #2

Expert Mod 10K+
P: 12,366
You have an extraneous semi-colon in the middle of the SQL
Mar 7 '19 #3

Post your reply

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