Show the average time in a report (1 Viewer)

[Carl_R]

This is a slight curveball on what I have found on calculating averages so here goes.

I have a function that I use in a query - it simply calculates the duration between two dates in Days Hours and Minutes.

I have a report based on this query, which returns the results as desired.

Is there a simply way to calculate the average number of days, hours and minutes in a Controls source property ( example =Avg([fieldname]) ) and have this appear in the report's group footer?

 

[khawar]

you can use avg(date1-date2)
replace date1 and date2 with your date fields
and after that apply that function to that average figure to display it in your format i-e days, hour, minutes
this have to be done in the query