Query to find missing numbers

[Randy]

I need a way to find missing accountable certificate numbers. I plan on
creating a database to imput certificate numbers received in the office from
headquarters. An example could be imputing certificates received, which
could be a range of A200200 to A 300000. (99,800 Certificates) I plan on
entering a begining Number and an ending number in my db. Certificates will
then be assigned to employees and then returned into the office after
completion. I will then enter the completed certificate numbers in the db.
Run a query to find any missing numbers. Does this sound feasable even
though I am not going to enter each individual certificate number in the
begining. Thanks ..Randy

 

[Douglas J. Steele]

Take a look at my April, 2004 Access Answers column in Pinnacle
Publication's Smart Access.

You can get the column (and the accompanying download file) at
http://members.rogers.com/douglas.j.steele/SmartAccess.html

 

[Randy]

I'm looking at creating a table where I enter a beginning sequencial number
and an ending sequencial number. I do not want to enter every sequencial
number which could number in the thousands. I will then have a table with
the actual issued sequencial number. I then need some kind of a query to
find any missing numbers...Is this possible for a novice? Thanks..Randy

 

[Douglas J. Steele]

Did you read the article? There are a couple of approaches there.