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

    Using WHERE with AND clause



      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!