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?
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?