Finding An Average

[ecuevas]

I have a customer concerns database that contains the dates for when the concerns were reported and tyhe dates for when the concerns were resolved. I am trying to make a query that finds the average of how long it takes for the concerns to be resolved. How can I do this?

 

[Rabbie]

Use a Query to calculate the time to resolve each concern and then use this to calculate the average.