WITH thisform months = (.text2.value-.text1.value)/30 SELECT a_id, a_sup, a_vin, MIN(a_startmile) as begin, vehicle.v_mileage as end, ; vehicle.v_mileage-MIN(a_startmile) as totalmile, INT((vehicle.v_mileage-MIN(a_startmile))/months) as average, ; a_unit as unit FROM veh_assign_tbl ; LEFT JOIN vehicle ON v_id = a_id ; GROUP BY a_sup, a_vin WHERE BETWEEN(a_startdate, .text1.value, .text2.value) INTO CURSOR test brows endwithI also noticed that when I type in
as averagethe word average didn't highlight as reserved word, but I'll take you advice and change that.