4 Replies Latest reply: Jun 23, 2010 10:45 AM by Chris Hopkins RSS

    Help with editing my script...

    Chris Hopkins

      Hi, this will be an easy one to answer,

      I am reporting on transactions for my company,I need to display my results for transaction numbers between 1000000 - 2000000 and exclude everything else.

      i know how to show values under a number i,e show values below transaction number 1000000.

       

      FROM $(cFileName) (qvd) WHERE DealNumber < 1000000 ;



      But how do i stop it from displaying values higher than 2000000

       

      Thanks