Find and Generate Missing Values in an Access Table

equential values can represent a lot in a database. Sometimes they uniquely identify records (as primary key values). Often they're part of the natural data, such as a purchase order number. In any case, a field of sequential values can be vulnerable to problems if a value goes missing, which can happen when you delete a record or a data entry operator simply skips the next value in the sequence. Even if missing values don't create a problem, you might need to account for them when conducting audits.

Now, Access can offer a lot of help with missing values, but finding and generating missing values in a field of sequential values requires a bit of code. The code in this article shows you how to generate a list of missing values. How you use those values is up to you.