Try this:

SELECT CustId, MAX(total_price) AS maxprice FROM yourtable INTO CURSOR curs1 GROUP BY CustId

SELECT curs1.CustId, yourtable.OrderNumber, curs1.maxprice) FROM yourtable INNER JOIN curs1 ON yourtable.CustID = curs1.CustID AND yourtable.total_price = curs1.maxprice INTO CURSOR endresult ORDER BY CustId, OrderNumber

If Max(total_price) equals the price of more than one order_number for a given Cust_id, you'll get both order_numbers.

>Oops. First() and Last() are aggregate functions available in Access 97 but apparently not in vfp6. Since I have done most of my aggregating in Access, I often think about SQL in Access terms. I'll have to think about this one a bit more. I have a feeling that the answer will involve more queries, one of which might number the records with RECNO(). There might be different queries that return Max(total_price) and order_number, which are then joined somehow. The answer will need to take into account the possibility that Max(total_price) may equal the price of more than one order_number for a given Cust_id.
>
>Or did you say that it was working now? If it is (and I don't see how) could you tell us what your SQL looks like?
>
>What is "berraquera"?
>
>>Thanks for your help. It worked with the two separated queries, but without the "LAST" function you suggest. What is that function? I did not even find documentation about it and got an error ("too many arguments") when i try to use it.
>>
>>Thanks again.
>>
>>>>Is it possible to get the maximum value from a field and other fields corresponding to the same record?
>>>>
>>>>i.e: Given a table with OrderNumber, CustId and total_Price, How do I get the highest total_price for every CustId and the Corresponding OrderNumber in a single query?
>>>>
>>>>I´ve tried something like:
>>>>Select CustId, OrderNumber,max(total_price) from [Tablename] group by CustId
>>>>
>>>>It returned the maximum value of "total_price" for every CustId, but the "OrderNumber" returned is not correct, given that in the source table the total_price for that Order_Number is not the same.
>>>>
>>>>Tks
>>>
>>>You might need two queries - one to order the records and another to give you your MAX.
>>>
>>>SELECT CustId, OrderNumber, total_price FROM yourtable INTO CURSOR curs1 ORDER BY CustId, total_price
>>>
>>>SELECT CustId, LAST(OrderNumber), LAST(total_price) FROM curs1 INTO CURSOR endresult GROUP BY CustId
>>>
>>>In the second query, LAST(total_price) and MAX(total_price) should give you the same thing.