Number of participants

[kuifje_007]

I want to count how many participants join in each tournament. I have a table which is manipulated by a recordset, so an example:

Tournament; Participant; MatchID; Round; Player
Australian Open; John; 1; 2e; Hantuchova
Australian Open; John; 2; 2e; Sharapova
Australian Open; John; 3; 2e; Golovin
Australian Open; John; 4; 2e; Davenport
Australian Open; Tim; 1; 2e; Hantuchova
Australian Open; Tim; 2; 2e; Sharapova
Australian Open; Tim; 3; 2e; Golovin
Australian Open; Tina; 4; 2e; Davenport
Australian Open; Tina; 1; 2e; Hantuchova
Australian Open; Tina; 2; 2e; Sharapova
Australian Open; Tina; 3; 2e; Golovin
Australian Open; Tina; 4; 2e; Davenport
Australian Open; Tina; 5; 2e; Krajicek
Wimbledon; John; 1; 2e; Hantuchova
Wimbledon; John; 2; 2e; Sharapova
Wimbledon; John; 3; 2e; Golovin
Wimbledon; John; 4; 2e; Davenport
Wimbledon; Tim; 1; 2e; Hantuchova
Wimbledon; Tim; 2; 2e; Sharapova
Wimbledon; Tim; 3; 2e; Golovin
Wimbledon; Tina; 4; 2e; Davenport
Wimbledon; Tina; 1; 2e; Hantuchova
Wimbledon; Tina; 2; 2e; Sharapova
Wimbledon; Tina; 3; 2e; Golovin
Wimbledon; Tina; 4; 2e; Davenport
Wimbledon; Tina; 5; 2e; Krajicek
Wimbledon; Tina; 4; 2e; Davenport
Wimbledon; Gabriel; 1; 2e; Hantuchova
Wimbledon; Gabriel; 2; 2e; Sharapova
Wimbledon; Gabriel; 3; 2e; Golovin
Wimbledon; Gabriel; 4; 2e; Davenport
Wimbledon; Gabriel; 5; 2e; Krajicek

As you see, there are many records with same participants and I want to count how many different participants are playing in each tournament. As you see this example, there are 3 participants who plays in Australian Open and 4 participants who plays in Wimbledon How do you do this?

 

[Pat Hartman]

Select Tournament, Count(*) As CountOfParticipants
From YourTable
Group by Tournament;

 

[kuifje_007]

Thanks, but they count all the participants together, for example: as for Australian Open it counts 13 participants and for Wimbledon 19 participants.

 

[Jon K]

qryOne:-
SELECT DISTINCT Tournament, Participant
FROM [YourTable];

qryTwo:-
SELECT Tournament, Count(*) AS CountOfParticipants
FROM qryOne
GROUP BY Tournament;


Run qryTwo.
.

 

[kuifje_007]

Yes, it works fine now! Thanks, Jon!