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.