>I am doing a select against a table with a group by clause, I wish to have the cursor contain the min and max values for the group, I am not getting the correct values. the select is as follows :
>sele district,route,min(odometer) as begin_point, .f. as found_beg, max(odometer) as end_point, .f. as found_end ;
>from pcs!pcs_locations group by district,route into cursor log_data
>
>TIA
>Ian


I suppose your need Min/Max group by route. ?