To speed up the SQL, use a variable in stead of the object value

lcMonth=thisform.month1.value
SELECT Acctran.code;
 FROM ;
     acctran;
 WHERE  Acctran.month1 = lcMonth;
 ORDER BY Acctran.month1

>

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