Add a text box in the report header or footer with these properties:
Name: txtReportTotalAmount
Control Source: =Sum(Amount)
Then in a group header or footer add a text box:
Control Source: =Sum(Amount)/txtReportTotalAmount
Duane Hookom MVP
MS Access
________________________________
> From: jaykay@sh163.net
>
>
> Happy New Year ...
> Can anyone shade some lights on how to express the total of a group
> over the total of all groups as a percentage in a report design?
> Example: Sum([Amount} for the group divided by Sum([Amount]) for the
> overall total. Regards, jay
>
__._,_.___
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (2) |
Please zip all files prior to uploading to Files section.
.
__,_._,___
Tidak ada komentar:
Posting Komentar