Print Page | Close Window

Gap Finder (GapFinder.mdb)

Printed From: Roger's Access Library
Category: Other Download Libraries
Forum Name: Cohen, Eric
Forum Description: Eric Cohen's Library
URL: www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=209
Printed Date: 28 Mar 2024 at 8:02am
Software Version: Web Wiz Forums 12.03 - http://www.webwizforums.com


Topic: Gap Finder (GapFinder.mdb)
Posted By: Eric Cohen
Subject: Gap Finder (GapFinder.mdb)
Date 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: http://www.rogersaccesslibrary.com/forum/uploads/9/GapFinder.zip - uploads/9/GapFinder.zip



-------------
--

No conditions apply to use of the code.
Email: mailto:tral0999@aol.com - tral0999@aol.com



Print Page | Close Window

Forum Software by Web Wiz Forums® version 12.03 - http://www.webwizforums.com
Copyright ©2001-2019 Web Wiz Ltd. - https://www.webwiz.net