Date Average

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

Guest

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.
 
Dates are stored as floating point numbers. You can simple subtract one from
another to get the difference in days and parts of days.
 
Back
Top