Roger's Access Library Homepage
Forum Home Forum Home > Other Download Libraries > Access-L Developer's Libraries > Cohen, Eric
  New Posts New Posts RSS Feed - Gap Finder (GapFinder.mdb)
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

>
Want a good read? Try The Summer of His Life (available on Amazon!)

Gap Finder (GapFinder.mdb)

 Post Reply Post Reply
Author
Message Reverse Sort Order
Eric Cohen View Drop Down
Contributor
Contributor


Joined: 24 Jun 2008
Status: Offline
Points: 1
Post Options Post Options   Thanks (0) Thanks(0)   Quote Eric Cohen Quote  Post ReplyReply Direct Link To This Post Topic: Gap Finder (GapFinder.mdb)
    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

--

No conditions apply to use of the code.
Email: tral0999@aol.com
Back to Top
Sponsored Links
>
Want a good read? Try The Summer of His Life (available on Amazon!)

Back to Top
 Post Reply Post Reply
  Share Topic   

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.03
Copyright ©2001-2019 Web Wiz Ltd.