|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
October 4th, 2004, 04:51 PM
|
|||
|
|||
How can I substract the lowest value from the highest value in a .
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. 
|
|
#2
October 4th, 2004, 05:17 PM
|
|||
|
|||
|
Set your control source or a text box in the group header or footer to:
=Max([MileageReading])-Min([MileageReading]) -- Duane Hookom MS Access MVP -- "Mileage Calculations" Mileage wrote in message ... 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.
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Excel VBA - Highest Value and Second Highest Value | Parlatoc | General Discussion | 1 | August 2nd, 2004 10:44 PM |
| Formula to count cells ignoring highest and lowest values | Baldy | Worksheet Functions | 4 | November 13th, 2003 05:38 PM |
| Seek highest value, but reflect column header instead | ManojB | Worksheet Functions | 5 | November 12th, 2003 10:51 PM |
| Highest and lowest value from column | DrB | Worksheet Functions | 2 | November 11th, 2003 01:39 AM |
Linear Mode
