count records in a table meeting criteria 1

[bill1one]

The following statement counts all the records in the table. How can I limit it to count only the records where [School] is "Souders"?

SELECT Count(*) AS [Number of Participants]
FROM tblParticipants;

 

[r937]

SELECT Count(*) AS [Number of Participants]
FROM tblParticipants
WHERE [School] = 'Souders'

r937.com | rudy.ca

 

[bill1one]

Great thanks.

 

[rstitzel]

SELECT Count(*) AS [Number of Participants]
FROM tblParticipants
WHERE [school] = "Souders"

 

[lespaul]

For future reference, if you want a count of all schools individually:

SELECT School, COunt(*) As [Number of Participants]
FROM tblParticipants
GROUP BY School

will return data like this:
School Number of Participants
Souders 75
Norders 60
Easters 56
Westers 100



Leslie

Anything worth doing is a lot more difficult than it's worth - Unknown Induhvidual