initial number and last number of interval

  • Thread starter Thread starter SL
  • Start date Start date
S

SL

i need search a number or numbers missing in the table

example:

table1
1
2
3
5
7
8
9
10
11

i´m input a initial number and last number of interval: 1-10

and result:

4
6

i like list too the numbers out of interval in the table
example:
11
 
Missing numbers are quite a different beast from out of sequence numbers.
Sounds obvious, but the consequences may not be immediately apparent.
As you pass through the numbers and find a 'hole' you then need to search
the whole set to see if it is indeed missing or just out of sequence.
Once you have determined valid missing numbers then you proceed to get the
out of sequence ones.
Using temp tables and the jet sql engine can make life a little easier.

See www.papwalker.com/public/outofseq.mdb

....for one of several ways to achieve both goals
--

peter walker MVP

Please post replies to the news group so everyone can benefit.
www.papwalker.com
 
It is that that I want, but I didn't understand because in the interval of
1 - 10

I SOO it is same the
5

where should be:

11
13
15
 
Back
Top