subtracting the highest and lowest value in a rep

[reel knotty]

Hi all very helpfull site!! I am designing a report for my company and I will have a list of odometer readings and I would like to subtract the lowest number from the largest number to get a total miles for the month. How do I select only those 2 values in my report?

Thanks in advance.
Nate

 

[simongallop]

Look at DMax and DMin in the help files

HTH

 

[reel knotty]

got it thanks