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.