>>I have an existing cursor statement which opens the cursor in ascending client then ascending created order
>>
>>How do I change the order to ascending client then DESCENDING created order
>>
>>Created is a datetime field
>>
>>SELECT created,accountno,acclient,quoteref FROM quotation ;
>> WHERE ! EMPTY(created);
>> ORDER BY acclient ,created INTO CURSOR quotelist readwrite
>>
>>Thanks
>>
>>Colin
>
>Add DESC after created
>

>
>>SELECT created,accountno,acclient,quoteref FROM quotation ;
>>	WHERE ! EMPTY(created);
>>	ORDER BY acclient ,created DESC  INTO CURSOR quotelist readwrite
>

Thanks a lot