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?