Calculate percentages in access report

G

Guest

I would like to know how to write an expression which calculates the
percentages in an Access report. I need to write an expression which
calculates the percentage of the grand total based on the cost of each
ProductName group. Cost1 and GrandTotal are to be used in the expression.
This is for a class and I just can't seem to grasp these functions.
 
A

Al Campagna

Marian,
To determine what percentage Cost1 (ex 100) is of the GrandTotal (ex 1000)...
Cost1/GrandTotal = .01
Formatted as percentage = 10%
If you need further asistance, please describe your Grouping, and use example values.

--
hth
Al Campagna . Candia Computer Consulting . Candia, NH USA
Microsoft Access MVP
http://home.comcast.net/~cccsolutions

"Find a job that you love, and you'll never work a day in your life."
 

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

Access 2003:how to calculate percentages in a report 1
Percentages on time calculations 3
Access Negative Percentages in Report in Access 2007 0
Calculate percentage 2
Pivot Table Percentage of Sub-Total 7
Formatting Percentages/LOOKUP using a Percentage 2
Access Query problem 1
Expression for Percentage Calculations Based Upon Subsets of Field 4

Top