Calculating & Avg time in a report

  • Thread starter Thread starter Dale Ring
  • Start date Start date
D

Dale Ring

Access 2000

Each record has several time fields (short time format).
I'm using
the following 2 Textboxes to determine actual "Scene Time"

[txtTotalTime]=DateDiff("n",[TimeArrivedScene],_
[TimeLeftScene])

[txtTotalSceneTime]=[txtTotalTime]\60 & Format_
([txtTotalTime] Mod 60,"\:00")

The field in the first calculation [TimeLeftScene] could
be blank at times.

All of the above is in the detail section.

What I need now is an Average Scene Time for the entire
report.

Any & All suggestions are truly appreciated!

Thanks
Dale
 
Dale said:
Access 2000

Each record has several time fields (short time format).
I'm using
the following 2 Textboxes to determine actual "Scene Time"

[txtTotalTime]=DateDiff("n",[TimeArrivedScene],_
[TimeLeftScene])

[txtTotalSceneTime]=[txtTotalTime]\60 & Format_
([txtTotalTime] Mod 60,"\:00")

The field in the first calculation [TimeLeftScene] could
be blank at times.

All of the above is in the detail section.

What I need now is an Average Scene Time for the entire
report.


Assuming that TimeArrivedScene and TimeLeftScene are fields
in the report's record source, try using a text box with the
expression:

=Avg(DateDiff("n",[TimeArrivedScene],[TimeLeftScene]))
 
Back
Top