Dates and Average

[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

 

[Duane Hookom]

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.