[AccessD] Calculating Date/Time

Do a Group By or Totals query, grouping on the person and averaging on
the number of days. Something like this

SELECT tblDataTable.PERSON_ID, Avg(tblDataTable.DaysToClose) AS AvgOfDaysToClose
FROM tblDataTable
GROUP BY tblDataTable.PERSON_ID;

You can write the results to a temp file if you need to by making it
into a Make Table query if you need to and then use that to update a
master file someplace.

GK

On 10/25/06, Hollis, Virginia <hollisvj at pgdp.usec.com> wrote:
> I got the DateDiff in days - so how do I get the Average number of days
> it took to close for each person?
>
>
>
>
> >I would use the DateDiff function
>
>
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>


-- 
Gary Kjos
garykjos at gmail.com