Calculating Average Time in the footer

[Rickstar321]

Hello! Novice here learning every day!

I know this should be simple but it is eluding me.

The query for my report (with a date parameter) is calculating time elapsed for each record, I am simply tryin to add an "Average Time" calculation in the footer. I am getting #Error.

I am working on the report but here is the SQL for the Query it is pulled from In case I have it wrong.

 SELECT TruckLog_tbl.Log_Date, TruckLog_tbl.Log_Time, TruckLog_tbl.Log_TruckLoaded_time, Format([Log_Time]-1-[Log_TruckLoaded_time],"Short Time") AS loadouttime
FROM TruckLog_tbl
WHERE (((TruckLog_tbl.Log_Date)=[What Date?]))
ORDER BY TruckLog_tbl.Log_Date, TruckLog_tbl.Log_Time;

I have not set grouping because my data will be looked at by day.

Thanks!!!

[Micron]

I am simply tryin to add an "Average Time" calculation in the footer.

Footer of what, query? Forget that and do grouping, sorting and group calculations in the report.

[ranman256]

in the query, there should be an elapsed time field,
in the report detail, show the E time,
in the report footer, add a E time field here to, then alter it's Control Source to : =AVG([time])

elapsed time is : DateDiff("n",startdate , endDate)

flag:
n = minutes
H = hours