Thank you Duane. As always you have been prompt and very helpful. Your tips led me to use the same tricks for other info on the report.
Regards, jay
--- In AccessDevelopers@yahoogroups.com, Duane Hookom wrote:
>
> 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@...
> >
> >
> > 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 (3) |
Please zip all files prior to uploading to Files section.
Tidak ada komentar:
Posting Komentar