Report Calculations

[Geri2004]

I have a report which shows different figures for 26 company's. examples of figures are growth factor, Net Amount Made for the year etc.... On this report I need to show a sum/total of some of these figures. I also need to show the average figures for some of these. How would I go about this ?

 

[BobJacksonNCI]

For quick (on your part) results, look at Dsum and Davg.

These WILL slow down report execution...

If the report(s) will be run frequently or by senior management, it would be faster executing to create and link queries to feed the sums and averages.



HTH,
Bob

 

[dhookom]

You didn't provide much information regarding your records/table structure. You can use text boxes in group and report footers with control sources like:
=Sum([YourField])
or
=Avg([YourField])
To average values for a limited number of records consider something like the following that averages the PayRate of all females:
=Sum(Abs(Gender="f") * PayRate) / Sum(Abs(Gender="f"))


Duane
MS Access MVP
Find out how to get great answers faq219-2884.

 

[nimarii]

I'm trying to sum up a calculated field on my report, but everytime i try to run the report, it doesn't work, as it doesn't recognize the calculated field name, and prompts for it when the report is run.

Here's the calculated field: (named RevisedCommission)
=IIf([orderdate]<#8/1/2004#,[commission]*0.2,[commission]*0.1)

and here's the sum:
=Sum([revisedcommission])

can anyone tell me what I'm doing wrong?

 

[dhookom]

You can't sum controls. You must use:[blue]
=Sum(IIf([orderdate]<#8/1/2004#,[commission]*0.2,[commission]*0.1))[/blue]


Duane
MS Access MVP
Find out how to get great answers faq219-2884.