Missing Number

[rockon69]

Can you tell me how I can identify missing numbers each contact has a unique number starting from 1001, but I need to identify missing ones in order, for example 1001,1002,1003,100. 1004 is missing.

please help

 

[cfneumann]

Only thing I can think of is to loop with a counter for the exceptions. Christopher F. Neumann
[dBASE Charter Member]
Blue Star Visual dBASE graduate
ICCP certified TCP/IP Network Analyst

http://members.aol.com/noahcneumann

 

[strangers]

ADO CONNECTION IN vb 6 TO DBASE III IS POSSIBLE.VIEWING OR BROWSING IS ALSO OK.BUT SAVE,DELETE,APPEND ETC. ARE NOT HAPPENING.MICROSOFT GET ENGINE IS NOT RECOGNIZING.
CAN ANYBODY HELP ME THERE?
GUNAJIT ROY