I currently have a report based on a query. The query has the fields
DateLookedAt, DateResolved and TimeTaken which displays the time
between the two other dates in the other two fields.

I need another field on my report to display the average of all data
in the TimeTaken field. Could anyone give me the SQL code to create
this extra field in my query.

Many thanks for any help.