Average dates

  • Thread starter Thread starter JLW
  • Start date Start date
J

JLW

I have a report that shows all pending cases and the date they were received.
Management wants to see the average date of the pending cases. I'm not sure
what calculation I need or if it needs to be in the query or if it will work
in the report footer. Any help is greatly appreciated. Thanks.
 
The average Date of the pending cases? That makes very little sense to
me. Can you expand on what that means?

If they want to know the average length of time (in days) that a case is
pending then I could understand the utility of gathering this information.

You could try adding a control to the report footer and set its source to
=DateAdd("d",(Avg(SomeDate),0)
That should return a date

'====================================================
John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
'====================================================
 
I know, it doesn't make sense to me either and I have tried talking them into
looking at the average days instead but they want the date. I tried the
following in the report footer and I think it may be giving me the correct
data but am not sure:

=Avg([Recieved Date])

This just seemed way to simple.
 
No that should work. When I was testing, I got back a number that
represented the date (and partial days).

Your expression should work since Dates are stored as a number and can
be averaged. You must remember that your average is going to be subject
to rounding. For instance, the average if you use Sept 1 and Sept 2 is
NOON on Sept 1 - so the date without time will be Sept 1. Sept 1 and
Sept 4 will be Sept 3 at NOON.


'====================================================
John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
'====================================================

I know, it doesn't make sense to me either and I have tried talking them into
looking at the average days instead but they want the date. I tried the
following in the report footer and I think it may be giving me the correct
data but am not sure:

=Avg([Recieved Date])

This just seemed way to simple.

John Spencer said:
The average Date of the pending cases? That makes very little sense to
me. Can you expand on what that means?

If they want to know the average length of time (in days) that a case is
pending then I could understand the utility of gathering this information.

You could try adding a control to the report footer and set its source to
=DateAdd("d",(Avg(SomeDate),0)
That should return a date

'====================================================
John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
'====================================================
Click to expand...
Click to expand...
 
Back
Top