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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Set your control source or a text box in the group header or footer to:
=Max([MileageReading])-Min([MileageReading])
 
Back
Top