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
