5 Replies Latest reply on Nov 2, 2012 7:54 PM by mcrostie

    Finding Numbers not used within a range

    mcrostie

      Hi All

       

      I require a way of finding missing numbers in a range of numbers in the same field (ImageNumber) over a number of records and then list them some way.

       

      ie number in Field "ImageNumber"....

       

      001

      002

      003

      004

      005

      008

      009

      010

      011

      012

       

       

       

      i wand to find numbers

       

      006

      007

       

      Thanks

       

      Michael

      FMA12