Percentage

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a report where I have calc'd field named "Sum([Granted])" and another
field that is calc'd from a query named "Sum of County". I am trying to
divide "Sum([Granted])" by "Sum of County" to get a percentage of the total.

I am using this expression on the report field: =Sum([Granted])/([sum of
county])
In this case access should be doing: 11730/51518 and should come up with
22.77%. (yes I do have the field referenced as a percentage) When I run the
report access freezes up.

How should I be referencing the query field Sum of County in the above
expression?
 
Try making the field a regular text field, and using the expression
=CStr(Sum([Granted])/([sum of county])*100 ) & "%"

Gijs van Swaaij
 
Back
Top