Finding a missing number in a series of numbers

firefighter2045 · July 30th, 2009, 02:06 PM

I need a method in visual basic to find the first number missing in a series of number.
If the series was 1, 2, 3, 4, 6, 7, 9 I need it to return 5. The series run from 0000 to 9999. If there was no missing numbers I need it to return something which I could use to activate some other code.

Old Pedant · July 30th, 2009, 05:45 PM

And *where* does this series of numbers exist??? In an array? In records in the DB? Or what?

firefighter2045 · July 31st, 2009, 07:27 AM

The data is located in an Access table