Gap Finder (GapFinder.mdb) |
Post Reply |
Author | |
Eric Cohen
Contributor Joined: 24 Jun 2008 Status: Offline Points: 1 |
Post Options
Thanks(0)
Posted: 10 Jul 2008 at 5:53am |
The attached zipped database contains a module with the code to determine the gaps. The source table is called testfile. It has one numeric field called custno. The output table which will contain the gaps is called GAPS. I have written the code with the assumption that there are no null values, no values out of sequence, and that the numbers are in ascending order. These conditions could all be coded for if the need were to arise.
Download Access 97: uploads/9/GapFinder.zip |
|
Sponsored Links | Want a good read? Try The Summer of His Life (available on Amazon!) |
Post Reply | |
Tweet
|
Forum Jump | Forum Permissions You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum |