Need Help Getting an AVG on time

[nufather]

I have an a database for trouble tickets , and heres my issue I have a Date Opened Date (format is : 06/03/99 11:18:00 AM) and a Closed Date (same format). What I need is to find out how long it takes to close a ticket and then the AVG time by Month. So....for the month of june the AVG close time for tickets was 1hr 32min or something like that.<br>
Thanx in advance for your help. - nufather

 

[bsilvert]

Not sure if this will solve the whole question, but given a table called "xxx" with date fields "dopen" and "dclose", then this query will group by month, sort Jan to Dec, and give the average per month in minutes:<br>
<br>
SELECT Format([dopen],"mmm") AS Month, Avg(DateDiff("n",[dopen],[dclose])) AS AverageTimeToClose<br>
FROM xxx<br>
GROUP BY Month([dopen]), Format([dopen],"mmm");