Return Average times within query?

[jmbcreative]

I have a need to create a chart showing the type of request and the average response time by roger. the data that I have collected in my query looks like below;

requestDate rogerDate type

3/08/2006 8:48:41 AM 3/08/2006 11:48:41 AM relocate
3/10/2006 8:20:41 AM 3/10/2006 11:32:41 AM add component

and so on. I would like to add a column to this query that shows the average response time for each request. I believe that this can be stated as a function in the column heading of the query, but I haven't the faintest I dea how to do this. Any ideas?

 

[jmbcreative]

Scratch that! I use the DateDiff function to get the results that I needed.

For those who are intersted,

ResponseTimebyHours: DateDiff("h",[requestDate],[rogerDate])

Gave me the response time in hours.

Joe