Hi,
Where do you have your SELECT statement? You can change the SELECT statement to use a variable in the WHERE clause:
MyFilter = "Status = 'Working' "
Select .... where &MyFilter .......
Then pass the variable to wherever you run the SELECT statement.
HTH
Barbara
>Hi:
>
> I have just created a report using Report designer. Now I only want to select only WORKING instead of PLANNING in status field of the report.
>
>SELECT
> Lispm ,;
> status ,;
> Start ,;
> Comp ,;
> Ssp ,;
> Msr ,;
> Avail ,;
> Ship ,;
> Hull ,;
> Chgs ;
>FROM Schd ;
>WHERE Status = "Working" ;
>ORDER By 1 ;
>INTO CURSOR Output
>
>1. Where shall I hard code this logic.