Re: Calculating the Average

hi Chris,

chris0309 via AccessMonster.com wrote:
> Difference in Hours
> ----------------------
> 4
> What i need is to work out the average and give the total at the bottom of
> the coloumn, but having no luck.
You need an extra band, e.g. you create a grouping footer or use the
report footer or the page footer. Place a TextBox in it. Assign
"=Avg([fieldName])" as its control source. Where fieldName is the name
of the field, not the control, used for your list in the detail section.


mfG
--> stefan <--