missing numbers

[Bre-x]

Hi,

Is there a way to find out what numbers are missing?

Example

Field: MyNumbers, Type: Integer

1,2,4,6,7,8,9,10

the missing numbers are 3 and 5

Regards,

Bre-x

 

[Douglas J. Steele]

See whether my April, 2004 "Access Answers" column in Pinnacle Publication's
"Smart Access" helps.

You can download the column (and sample database) for free at
http://www.accessmvp.com/DJSteele/SmartAccess.html

 

[Bre-x]

Thanks for the info, the solution is there: April 2004: Mind the gap, take
your time, and how long is a string?

Also, I saw very interesting programming tips.

very much appreciate


Bre-x