I have a report for Employee Travel Log. One of the controls shows the odometer reading. The travel is grouped by employee and date. In the group footer I have a control that subtracts the minimum odometer reading from the maximum odometer reading, and this is their Daily Mileage. The next day they will have a new odometer reading at the start of the day.
What I want to do is Sum all the Daily Mileages for the employee. I have tried setting a text box control in the employee group footer to = Sum([DailyMileage]) but it returns nothing.
Any suggestions on how I can accomplish this?