mcrostie

Finding Numbers not used within a range

Discussion created by mcrostie on Nov 1, 2012
Latest reply on Nov 2, 2012 by 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

Outcomes