Calculation In A Report

[Guest]

I have a report based on a table which is grouped by a field called Department.

I want the totals of each department as a percentage of the total number of
records

=count([department]) in the Department footer gives me the total of each
department. How can I express this as a percentage of the total number of
records in the table?

 

[Duane Hookom]

If "in the table" is the same as "in the entire report", add a text box to
the Report Header section:
Name: txtCountAll
Control Source: =Count([Department])
Then in your department footer, you can use:
Control Source: =Count([Department])/txtCountAll

 

[Guest]

That is great - thank-you very much - works EXACTLY as I want it to!!
Duane you rock

If "in the table" is the same as "in the entire report", add a text box to
the Report Header section:
Name: txtCountAll
Control Source: =Count([Department])
Then in your department footer, you can use:
Control Source: =Count([Department])/txtCountAll
--
Duane Hookom
MS Access MVP

I have a report based on a table which is grouped by a field called
Department.

I want the totals of each department as a percentage of the total number
of
records

=count([department]) in the Department footer gives me the total of each
department. How can I express this as a percentage of the total number of
records in the table?