SQL question will be used later in Excel

[Kurt]

Hello Everyone,

I have a cross table query in Access that I need to run in SQL Server. Here is the code:

TRANSFORM Sum([track apps].Apps) AS SumOfApps
SELECT [track apps].Branch
FROM [track apps]
GROUP BY [track apps].Branch
PIVOT [track apps].MONTH;

I am running SQL Server 2005.

I get the error message:

Msg 170, Level 15, State 1, Line 1
Line 1: Incorrect syntax near 'trackapps'.
Msg 170, Level 15, State 1, Line 5
Line 5: Incorrect syntax near 'PIVOT'.

I would appreciate any help on this.

TIA

Kurt

 

[Kurt]

Additional info

Hello again,

I am also trying to get this to work in Excel vba.

I forgot to add that.

Thanks,

Kurt

 

[mbb4331]

How about bringing the data straight from SQL into Excel, then do a pivottable.

 

[Kurt]

Pivot table

Hello,

Yes I am looking at that possibility also.


Kurt

 

[kylefraney]

I'm unsure as to what the error is but in the past I've cut and pasted SQL statements from Access to Excel via MS Query. Just another option I thought I would throw out there.

 

[Kurt]

MS Query

Hello Kyle,

Thanks for your suggestion.

I am also looking at MS Query you can get a SQL View there as well.

Kurt