Discussion Locked

check number sequence in MS Access table

0 helpful
3 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I have a table in MS Access need to check for any missing document numbers.
for example:
021901110
021901112
021901113
021901115
021901118
021901120
How do I write a query to pick up the missing ones?

3 replies

This discussion is closed to new replies.