Subtracting Lowest from Highest Value

[kalyhan]

Hi Everyone.

Not sure I can do this or not, but I'll check anyway.

My users are entering in three sets of high and low measurements
(High1, Low1, High2, Low2, High3, Low3) for a particular part number.

I have already set the db up to auto calculate the sum and the average of
these six values.

Is there any way to "find" the lowest reading and subtract it from the highest
reading?

Thanks in advance for any assistance.

Best Regards,
Karen

 

[Lance]

Take a look at the dmax and dmin functions. They should do it for you.

 

[kalyhan]

Thanks Lance. I will try this.

Take a look at the dmax and dmin functions. They should do it for you.