Compute Average Days

  • Thread starter Thread starter Ann
  • Start date Start date
A

Ann

I need some help. I would like create a sum total of days
that trucks sit on a lot that would sum those number of
days and calculate the average days they sat on the lot.

This is what I currently have on the Report,
Field name = Total Time (unbound field)
Field names on report = Date and Time In and Date and Time
Out.
Total Time formula =DateDiff("d",[Date and Time In],[Date
and Time])is working fine.
How do I sum those total number of days on the report
using Total Time formula, then compute the Average days?

Any help would be greatly appreciated.

Thank you,
Ann G.
 
Ann said:
I need some help. I would like create a sum total of days
that trucks sit on a lot that would sum those number of
days and calculate the average days they sat on the lot.

This is what I currently have on the Report,
Field name = Total Time (unbound field)
Field names on report = Date and Time In and Date and Time
Out.
Total Time formula =DateDiff("d",[Date and Time In],[Date
and Time])is working fine.
How do I sum those total number of days on the report
using Total Time formula, then compute the Average days?
Click to expand...

Use a text box in the report footer section and set its
expression to:

=Sum(DateDiff("d",[Date and Time In],[Date and Time]))
or
=Avg(DateDiff("d",[Date and Time In],[Date and Time]))
 
Back
Top