How can I substract the lowest value from the highest value in a .

  • Thread starter Mileage Calculations
  • Start date
M

Mileage Calculations

I am calculating mileage. I need to subtract the lowest value from the
highest value out of several values in a group to get the miles driven.
 
D

Duane Hookom

Set your control source or a text box in the group header or footer to:
=Max([MileageReading])-Min([MileageReading])
 
Top