SELECT Acctran.code;
   FROM acctran;
   WHERE Acctran.month1 = (thisform.month1.value);
   INTO CURSOR curTemp;
   ORDER BY Acctran.month1

HTH

>

Set Filter To code=thisform.code.value
> Set Order To month1
> LOCATE

>
>
>i try
>

>SELECT Acctran.code;
> FROM ;
>     acctran;
> WHERE  Acctran.month1 = (thisform.month1.value);
> ORDER BY Acctran.month1
>

>
>when i convert in sql (query) i get a brows. How avoid the brows i want only filter and order by sql