Calculating entries in a group

[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.

 

[KARL DEWEY]

Use this query ---
SELECT YourTable.[Institution], Count(YourTable.[Institution]) AS
[CountOfInstitution]
FROM YourTable
GROUP BY YourTable.[Institution];

 

[Ken Sheridan]

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