Gary,
>>> PRINT ft_item_store WHERE wmweek = 201135 + AND (ft_store <> 'o' OR ft_store <> 'x') + OPTION SCREEN <<<< Should be: PRINT ft_item_store WHERE wmweek = 201135 + AND (ft_store <> 'o' AND ft_store <> 'x') + OPTION SCREEN Or you can use: PRINT ft_item_store WHERE wmweek = 201135 + AND ft_store NOT IN( 'o','x') + OPTION SCREEN Javier, Javier Valencia, PE O: 913-829-0888 H: 913-397-9605 C: 913-915-3137 From: [email protected] [mailto:[email protected]] On Behalf Of Gary Wendike Sent: Thursday, September 29, 2011 11:34 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Print Command I am trying to print a report and bring back what I call exception columns. Within Wal-Mart there are various listings for the Forecast Types(FT) assigned to stores. Based on this FT, the store will re-order the product correctly or not at all. The following is the columns I am trying to print and the code. Item No Description Store No Valid Code WM Week FT The code I am using is very simple... PRINT ft_item_store WHERE wmweek = 201135 + AND ft_store <> 'o' + OPTION SCREEN This brings back all stores except those with a FT of 'O'. This is as expected. When I try to use the following code.... PRINT ft_item_store WHERE wmweek = 201135 + AND (ft_store <> 'o' OR ft_store <> 'x') + OPTION SCREEN This brings back a report and includes all of the 'O' FT which I am trying to eliminate. FT 'O' is the most prevalent and correct FT used in the system. I am trying to review the exceptions. Can anyone see a problem with the code? Thanks Gary
