Thanks. What if I had replace the "MAX(a_startmile) as end" with a mileage from another table. For instance, the ending mileage is in my vehicle table, I can find it with v_vin (vehicle number). Would I have to scan through my intial cursor while building another cursor with ending miles from vehicle table and then put the two tables together?

>Add grouping by a vehicle number.

...
>GROUP BY a_sup, a_vin, ;
>...

>
>>I am having difficulty in using my sql statement. What I have is a table that has supervisor, vehicle number, mileage, assign date. I have a form where the user puts in starting assign date and ending assign date. Both dates a looking at a_startdate. What I am trying to do is group supervisor by their a_vin which would look the following
>>
>>

>>sup1 veh1 100 200 100 someavg someunit
>>sup1 veh2 100 300 200 someavg someunit
>>sup2 veh3 100 200 100 someavg someunit
>>sup2 veh4 100 200 100 someavg someunit
>>sup2 veh5 100 200 100 someavg someunit
>>.....
>>sup9 veh20 20  40  20 someavg someunit
>>
>>

>>
>>I think I am missing something below and I can't seem to rig it the right way
>>
>>

days = (.todate.value-.fromdate.value)*30
>>
>>SELECT a_id, a_sup, a_vin, MIN(a_startmile) as begin, MAX(a_startmile) as end, ;
>>	MIN(a_startmile)-MAX(a_startmile) as totalmile, ;
>>       (MIN(a_startmile)-MAX(a_startmile))/days as average, ;
>>	a_unit as unit FROM veh_assign_tbl ;
>>GROUP BY a_sup WHERE BETWEEN(a_startdate, .fromdate.value, .todate.value) ;
>>INTO CURSOR test
>>	brows

>>
>>
>>Can anyone see something wrong here?
>>
>>Thanks
>>Nick Patel