initial number and last number of interval

[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

 

[Cheryl Fischer]

Frank,

Have a look at the following article:

ACC: How to Flag Out-of-Sequence Numbers on a Report
http://support.microsoft.com/default.aspx?scid=kb;en-us;137118

 

[peter walker]

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

 

[Frank Dulk]

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