Hello, I have attached two pics of my login form. The "working login form.jpg" shows: Starting Mileage = 88, Ending Mileage = 92, Total Mileage = 4 So EndingMileage (92) - Starting Mileage (88) = Total Mileage (4) This works fine. The "nonworking login form.jpg" shows: Starting Mileage = 99, Ending Mileage = 105, Total Mileage = 0 So EndingMileage (105) - Starting Mileage (99) = Total Mileage (0) This does NOT work. Please help. Either vbscript or arcpad 7.1.1 thinks that the first number in Starting Mileage (9) in the 99 value is greater than the first number in Ending Mileage (1) in the 105 value???? I can get this formula to work if I add a 0 in front of the 99 in Starting Mileage.... so this works Ending Mileage (105) - Starting Mileage (099) = 6, but I don't want my users to have to put a 0 in front of a number if it was 99 miles, and then there speedometer goes to 105 miles..... How can I get around this issue??? Is there some script I can write in vbscript? thank you James Ireland GIS Technician
... View more
