>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