Small prob in access

[Lasse Edsvik]

Hello

I was wondering if you guys could help me with this simple one

I have a Results table with Teams and their points. And i want to find out
the teams rank.


Team Points Player
A 1 AA
A 4 AB
A 2 AC
B 5 BB
B 5 BC
C 4 CC


would like to have the following result

Team Rank
B 1
A 2
C 3


or just

Team
B
A
C

and i'll use a counter in my asp-page that prints out 1,2,3..... infront of
the teams names

TIA
/Lasse

[Bob Barrows]

Lasse Edsvik wrote:

> Hello
>
> I was wondering if you guys could help me with this simple one
>
> I have a Results table with Teams and their points. And i want to
> find out the teams rank.
>
>
> Team Points Player
> A 1 AA
> A 4 AB
> A 2 AC
> B 5 BB
> B 5 BC
> C 4 CC
>
>
> would like to have the following result
>
> Team Rank
> B 1
> A 2
> C 3
>
>
> or just
>
> Team
> B
> A
> C
>
> and i'll use a counter in my asp-page that prints out 1,2,3.....
> infront of the teams names
>
> TIA
> /Lasse

Select Team From Results
Group By Team
Order By Sum(Points) DESC

HTH,
Bob Barrows

--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.