5 Replies Latest reply: Dec 17, 2014 6:31 AM by Melissa van Kluyve RSS

    Using WHERE with AND clause

      Hello,

       

      I am trying to use a WHERE clause with an AND clause to achieve the following:

       

      Actual Volume should only be loaded if >= 0.

      No data should be loaded if Forecast and Actual both = 0.

       

      I have tried the following but it seems to eliminate records where Forecast = 0 but Actual does not.

       

      WHERE [Actual Volume] >='0' AND ([Actual Volume] <> '0' AND [Forecast Volume]<> '0');

       

      I'm not sure if I'm perhaps using AND incorrectly or misplacing my ().

       

      Thanks for your help!

       

      M