Averages

[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

 

[Guest]

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.

 

[Marshall Barton]

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.

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