So, did you get all the desired results now?

>I had the parenthesis in wrong place, Sergey helped me out, but here is the statement I was getting at:
>
>
>.text2.value has date of 07/16/02
>.text1.value has date of 01/01/02
>vehicle.v_mileage = 50
>min(a_startmile = 20
>totalmile = 30
>
>I am trying to find average miles per month
>
>

>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
>
>endwith
>

>
>I also noticed that when I type in
>

as average

>the word average didn't highlight as reserved word, but I'll take you advice and change that.
>
>Thanks
>Nick Patel