i'm trying to pull back the maximum mileage on a vehicle from a fuel system dump.
The data is on the left of the screen shot, the summary page is on the right.
i need to do a lookup using the unit number (truck number) from the summary to the data to return the max mileage (current mileage) on each vehicle.
)) only returns me the first value on the mileage for that truck number not the greatest.
any help would be greatly appreciated.