Access 2003:how to calculate percentages in a report

  • Thread starter Thread starter peanut
  • Start date Start date
P

peanut

I need to know how to calculate percentages in a report, in design view.
Calculate the percentage of the grand total based on the cost of each
ProductName group. (Hint You use the names Cost1 and GrandTotal in the
matematical expression.
 
peanut said:
I need to know how to calculate percentages in a report, in design view.
Calculate the percentage of the grand total based on the cost of each
ProductName group. (Hint You use the names Cost1 and GrandTotal in the
matematical expression.
Click to expand...


Put the GrandTotal textbox in the report header section and
use an expression like =Sum(Cost1)

Then you can use a text box in the group header or footer
section with an expression like =Sum(Cost1) / GrandTotal

If you want a percentage for each detail record, the detail
text box expression would be like =Cost1 / GrandTotal
 
Back
Top