More dynamic...

[Flemming]

Hi

Thank you for taking time to help me out.

I have a table containing
YearNo,*,*,*, PlayerID, Initials,*,*,*,RojterCupPoints,*,*,*

RojterCupPoints determin weither a match was won, squared og lost.

RojterCupPoints > 3 'Won
RojterCupPoints = 3 'Squared
RojterCupPoints < 0 'Lost


YearNo, PlayerID, Initials, Count of Won, Cound of Squared, Count of Lost
2006 1 FV 4 1
1
2005 1 FV 4 0
2
2006 2 KB 1 0
5
2005 2 KB 3 0
3

Thanks
Flemming

 

[John Spencer]

The SQL statement would look like the following:

SELECT YearNo, PlayerID, Initials
, Abs(SUM(RojterCupPoints>3)) as Won
, Abs(SUM(RojterCupPoints=3)) as Squared
, Abs(SUM(RojterCupPoints<3)) as Lost
FROM [SomeTable]
GROUP BY YearNo, PlayerID, Initials

If you don't know how to build an SQL statement in the SQL view, post back
for instructions on how to do this in the query design view (grid)

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

 

[Flemming]

Hi John

That was JUST what I needed - I'm learning to get there *S*

Thanks
Flemming

The SQL statement would look like the following:

SELECT YearNo, PlayerID, Initials
, Abs(SUM(RojterCupPoints>3)) as Won
, Abs(SUM(RojterCupPoints=3)) as Squared
, Abs(SUM(RojterCupPoints<3)) as Lost
FROM [SomeTable]
GROUP BY YearNo, PlayerID, Initials

If you don't know how to build an SQL statement in the SQL view, post back
for instructions on how to do this in the query design view (grid)

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
.

Hi

Thank you for taking time to help me out.

I have a table containing
YearNo,*,*,*, PlayerID, Initials,*,*,*,RojterCupPoints,*,*,*

RojterCupPoints determin weither a match was won, squared og lost.

RojterCupPoints > 3 'Won
RojterCupPoints = 3 'Squared
RojterCupPoints < 0 'Lost


YearNo, PlayerID, Initials, Count of Won, Cound of Squared, Count of Lost
2006 1 FV 4 1 1
2005 1 FV 4 0 2
2006 2 KB 1 0 5
2005 2 KB 3 0 3

Thanks
Flemming