I am ultimately trying to create a query to get the average hours/minutes per month a specific employee rides a bike. I successfully completed this task with miles, however am having problems with getting the average time/month.
For the Miles, I created a query showing my start and ending mileage and then created a calculated field to get the total miles per day. I then took the total miles per/day per employee and sumed up the total miles ridden and divided that by the number of days, in this case the number of records for each individual person.
I presume I need to do the same with the Time, but i keep get an error indicating the expression is unmatched? Any help would be greatly appreciated.
For the Miles, I created a query showing my start and ending mileage and then created a calculated field to get the total miles per day. I then took the total miles per/day per employee and sumed up the total miles ridden and divided that by the number of days, in this case the number of records for each individual person.
I presume I need to do the same with the Time, but i keep get an error indicating the expression is unmatched? Any help would be greatly appreciated.
