Date Average

J

joe

I have two date fields...one for date received and another for date
done.Does access have a query to calculate an average time between the two
dates.This is for the purpose of monitoring average time for users to
complete a transaction.
 
D

Duane Hookom

Dates are stored as floating point numbers. You can simple subtract one from
another to get the difference in days and parts of days.
 
Top