Average in Footer

[Novice1]

In my query I compute the wait time for each customer ([TimeIn]-[TimeOut]), using the Short Time format. Works fine.

In my report, in the Details footer, I computer the average wait time Avg([waittime]). Works fine.

In my Report footer, I want the average waittime for the report period. Again I use =Avg([waittime]). This doesn't work. I get a very high, inaccurate number (over 17 hours)

I checked the data to see if there was wrong info in either of the time in or time out fields. No problems.

Am I computing the average in the report footer incorrectly?

 

[jdraw]

See if this free youtube video helps.
https://www.youtube.com/watch?v=16R4YgNt_Rk

 

[arnelgp]

if on the detail the avg is correct, on the footer textbox control, just refer to your avg in your detail textbox:

your textbox control source on footer:

=[textboxOnDetail]

if you dont want to show textboxOnDetail, just make the control textboxOnDetail not visible.

 

[Novice1]

Thank you. Simple.