Compute Average Days

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

Marshall Barton

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formula within Pivot Table Calculated Field - Days in time period 0
How To Rapidly Copy Formulas? 0
Average cases handled per agent in Sorting and Grouping report 0
calculations in report controls 2
Access Report Average Miles/Gallon in Group Footer and Report Footer? 9
Number of Days? 2
Calculating averages 13
Why is the average in my report footer giving the wrong calculation? 3

Top