473,408 Members | 1,676 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,408 software developers and data experts.

Syntax error in TRANSFORM Statement

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
2 2017
twinnyfo
3,653 Expert Mod 2GB
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
Rabbit
12,516 Expert Mod 8TB
You have an extraneous semi-colon in the middle of the SQL
Mar 7 '19 #3

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

Similar topics

3
by: Robert Mark Bram | last post by:
Hi All! I have the following two methods in an asp/jscript page - my problem is that without the update statement there is no error, but with the update statement I get the following error: ...
29
by: shank | last post by:
1) I'm getting this error: Syntax error (missing operator) in query expression on the below statement. Can I get some advice. 2) I searched ASPFAQ and came up blank. Where can find the "rules"...
3
by: KevLow | last post by:
Hi, Hope some kind soul can help me out here.. I'm trying to programmatically modify the column headings of a crosstab query such that it can be dynamic based on user specified period (Month...
7
by: kosta | last post by:
hello! one of my forms communicates with a database, and is supposed to add a row to a table using an Insert statement... however, I get a 'oledb - syntax error' exception... I have double...
3
by: Nathan Sokalski | last post by:
When trying to submit data to an Access database using ASP.NET I recieve the following error: System.Data.OleDb.OleDbCommand.ExecuteCommandTextErrorHandling(Int32 hr) +41...
1
by: amitbadgi | last post by:
HI i am getting the foll error while conv an asp application to asp.net Exception Details: System.Runtime.InteropServices.COMException: Syntax error in UPDATE statement. Source Error: Line...
5
by: amitbadgi | last post by:
Hi guys, I am getting the following error in teh insert statement , I am converting this asp application to asp.net, here is teh error, Exception Details:...
6
by: Blake Rice | last post by:
Please help make this work, I have tried any number of different ways to escape the quotes and not one of them has worked. It always comes up with a Syntax error, which tells me that I am just not...
1
by: shawnjerome | last post by:
I am attempting to combine 2 crosstab queries and I keep getting the "Syntax error in TRANSFORM statement". TRANSFORM Sum(tblPlanSavings.) AS SumOfPlanSavings SELECT tblPlanSavings.,...
3
by: asyrofifarel | last post by:
#include<stdio.h> #include<conio.h> main() { int hp,jp,ap,jb,ht float ht; printf("-->LankBuana Audio System<--"); printf("\n======================"); printf("\nMASUKAN NAMA PEMBELIAN = ");...
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...
0
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.