Dates and Average

  • Thread starter Thread starter joe
  • Start date Start date
J

joe

Hello,

In my design, i have two dates which will stand for date
of credit request received and date for credit request
done.Is there a way in either query or reports, that an
average time can be calculated to determine how long it
took from date received to date done?

Thanks
 
You can find the difference between two dates by subtracting one from the
other:
DaysBetween: [DateTwo] - [DateOne]
You can average this difference in a totals query.
 
Back
Top