Access 2003:how to calculate percentages in a report

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.
 
M

Marshall Barton

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calculate percentages in access report 1
Percentages on time calculations 3
Trouble with my sorting and grouping 2
Getting Percentages Correct 3
How do I calculate percentages in a report? 1
percentages calculated for a report 1
Count Number of Yes's in a Yes/No field 1
Access Negative Percentages in Report in Access 2007 0

Top