Percent to Total Calculation within Report 1

[mssbass]

I'm pretty new to access - I have a report that links to my query and the layout is simple:

Service #Pkgs % to Total

My query gives me the service type and number of packages that are associated with each service - NOW, how do I add on the column that shows for each service, what's the percent to total all packages?

 

[THWatson]

mssbass
Here's one method.

1. In the Report Footer, put an unbound text box that has as its control source the following expression...
=Sum([#Pkgs]). Let's name that text box something such as txtSumPkgs

2. In the Detail section, put an unbound text box that has as its control source the following expression...
=[#Pkgs]/[txtSumPkgs] and set its Format to Percent, and apply the number of decimal places you wish to show.

Tom