Calc % of Total

[Guest]

I have a report showing Dollars by Month [=sum([Orig_CM_AMT])] in the detail
with a calculation of total dollars in the group footer. In the detail, next
to each Dollars by Month, I would like to indicate the % of total dollars
generated during that month. This requires dividing the sum in the detail by
the sum in the footer. Any ideas? Thanks.

 

[Roger Carlson]

You could use the DSum() function to independently calculate the sum of the
records represented in the report. If it's a multi-page report, however,
this might be difficult.

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

 

[Marshall Barton]

I have a report showing Dollars by Month [=sum([Orig_CM_AMT])] in the detail
with a calculation of total dollars in the group footer. In the detail, next
to each Dollars by Month, I would like to indicate the % of total dollars
generated during that month. This requires dividing the sum in the detail by
the sum in the footer.

Do the group total calculation in the group header so it's
available in the detail.