Translate to Access - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Transact-SQL (2005)

Translate to Access

Author

Topic

Dragomir
Starting Member

4 Posts

Posted - 2008-01-17 : 07:00:16

How to translate this query into MS Access syntax?

SELECT G.GP,
SUM(case when G.MR = 1 then G.KOL else 0 end) '1',
SUM(case when G.MR = 2 then G.KOL else 0 end) '2',
SUM(case when G.MR = 3 then G.KOL else 0 end) '3',
SUM(case when G.MR = 4 then G.KOL else 0 end) '4',
SUM(case when G.MR = 5 then G.KOL else 0 end) '5',
SUM(case when G.MR = 6 then G.KOL else 0 end) '6',
SUM(case when G.MR = 7 then G.KOL else 0 end) '7',
SUM(case when G.MR = 8 then G.KOL else 0 end) '8',
SUM(case when G.MR = 9 then G.KOL else 0 end) '9',
SUM(case when G.MR = 10 then G.KOL else 0 end) '10',
SUM(case when G.MR = 11 then G.KOL else 0 end) '11',
SUM(case when G.MR = 12 then G.KOL else 0 end) '12',
SUM(G.KOL ) TOT
FROM PKW_2006 G
GROUP BY G.GP

It is very urgent!!!!
Thanks in advance.

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2008-01-17 : 07:26:50

SELECT G.GP,
IIF(G.MR = 1 ,G.KOL,0) as [1],
IIF(G.MR = 2 ,G.KOL,0) as [2],
.
.

But I think you can make use of Access's TRANSFORM

Madhivanan

Failing to plan is Planning to fail

Dragomir
Starting Member

4 Posts

Posted - 2008-01-17 : 07:31:29

Thanks a lot.

I will try

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources