Calculating entries in a group

  • Thread starter Thread starter amandap83
  • Start date Start date
A

amandap83

I have a database that lists all applicants, and I have a report that sorts
them according to which Institution they are attending. How can I have the
report display the number of applicants that are attending each Institution.
For example , Four applicants from Harvard, 10 Applicants from Columbia, ect.
 
Use this query ---
SELECT YourTable.[Institution], Count(YourTable.[Institution]) AS
[CountOfInstitution]
FROM YourTable
GROUP BY YourTable.[Institution];
 
Presumably the report already has a group level on the Institution field set
via the Sorting and Grouping dialogue in report design view. If this does
not already have a group footer then give it one via the dialogue. In the
group footer add a text box with a ControlSource property:

=Count(*)

You can alternatively use a group header if you prefer.

Ken Sheridan
Stafford, England
 
Back
Top