Query about Avg

[DaleFromEngland]

Good morning folks (Well it will be if i can figure this out!)

Right this is my question:

I have a table called Help_Desk_Problems_Subform. This form allows the user to enter info about a computer problem, Date of call taken, date of call closed and so on.

What the user does is that they enter the date the call was taken, The 1st date of response, and the date that the call was closed.
I want to work out the average of all three fields, the average of the 1st date of response compared to the date the call was taken, and the average of the date the call was closed for the the overall average of the date the call was taken and the 1st date of call taken. A bit confussing i know. i would be grateful to hear from anyone who could slove this problem. Also the feilds are all date fields!

Thankyou

 

[pcs]

not sure i understand completely, but:

create a select query on you table and add 3 expressions:

Expr1:
DateDiff("d",[call_taken],[first_res])

Expr2: DateDiff("d",[call_taken],[Call_closed])

Expr3: DateDiff("d",[first_res],[Call_closed])

this will give the number of days between each event.

create another query with the above as its record source. change it to a summation query and select GroupBy: Ave.

hth,
al





[This message has been edited by pcs (edited 09-03-2001).]