Averages

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Okay, I have [date1]-[date2]=cycletime. In a query how can I have a field
that reports the total average of all the records for the cycletime? So say I
have 50 records I would like to know the average of days(cycletime) for all
50 records.

Thanks

Marc
 
One way is to do a totals query and select Average. When you are in Query
design view, select the view menu and choose Totals. Select the cycletime as
the field and on the totals line change from Group by to Average.
 
Marc said:
Okay, I have [date1]-[date2]=cycletime. In a query how can I have a field
that reports the total average of all the records for the cycletime? So say I
have 50 records I would like to know the average of days(cycletime) for all
50 records.
Click to expand...


Avg(DateDiff("d". date2, date1))
 
Back
Top