I don't have the script with me but what i'am attempting to is make the script read the max (stop) min (stop) in the sql statement. When I get the result have it take the difference between the two to always give me the total accumulated miles from the field.
The sql statement looks like this:
SELECT *
FROM mileage, lsv
WHERE (mileage.vid = lsv.vid)
SORT BY reg
When I insert max(stop) and min(stop) next to select, it errors out.
Help!:mad:
