Calculating the Average

[chris0309 via AccessMonster.com]

Hi All,

Iv got a report which works out the difference between two date and time
columns that produces the results below:

Difference in Hours
----------------------
4
6
8
10
3
5

What i need is to work out the average and give the total at the bottom of
the coloumn, but having no luck.

Cheers for any help.

Chris

 

[Stefan Hoffmann]

hi Chris,

Difference in Hours

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

 

[Marshall Barton]

Iv got a report which works out the difference between two date and time
columns that produces the results below:

Difference in Hours
----------------------
4
6
8
10
3
5

What i need is to work out the average and give the total at the bottom of
the coloumn, but having no luck.

Assuming you used the DateDiff function to calculate the
hours, use a text box in a group and/or report (not page)
footer section with an expression like:
=Avg(DateDiff("h", dtfield2, dtfield2)