Access: Calculate the Percentage of Records in a Group

Posted August 8, 2004 by Lilliabeth in Microsoft Office

With Access, counting the number of records in a group is easy. However, determining that number’s percentage of the report’s overall record count is no simple task. This tutorial explains how to calculate the percentage by following a few simple steps.


To calculate the percentage of records in a group, follow the directions given in the following steps:

First, add a textbox control to the report’s Detail section and name it txtCountAll. Then, set its Visible property to No and set its Control Source property to the following:

=Count(*)

Then, add a textbox control the group footer. Name the new control txtCountGroup and set its Visible property to No. As before, set its Control Source property to the following:

=Count(*)

Next, add another textbox to the group footer and set its Control Source property to the following:

=txtCountGroup/txtCountAll

Finally, set the new textbox control’s Format property to Percent.

The Conversation

Follow the reactions below and share your own thoughts.