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.
Code:
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!!!