Averaging a summed field

[Guest]

Hi,
I have a report that I am creating that I would like to average the number
of days it takes for processing. The equation i'm using to create the
difference in dates is:
=Sum(DateDiff("d",[Date Complete],[Date Received])) and I would like to
average that. Can someone give me any help? Thanks in advance! Denise

 

[John Vinson]

Hi,
I have a report that I am creating that I would like to average the number
of days it takes for processing. The equation i'm using to create the
difference in dates is:
=Sum(DateDiff("d",[Date Complete],[Date Received])) and I would like to
average that. Can someone give me any help? Thanks in advance! Denise

On a Report you can put this expression into the Query upon which the
report is based; e.g. type

ProcessingTime: Sum(DateDiff("d",[Date Complete],[Date Received]))

Put this field on the report's detail section, and on the Footer
(either the Report Footer or the sorting-and-grouping section footer
if you want to average over a subset of the data) put

=Avg([ProcessingTime])

John W. Vinson[MVP]