Gap Finder (GapFinder.mdb)

Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic

   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

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
Eric Cohen Members Profile Send Private Message Find Members Posts Add to Buddy List Contributor Joined: 24 Jun 2008 Status: Offline Points: 1	Post Options Post Reply Quote Eric Cohen Report Post Thanks(0) Quote Reply 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

Sponsored Links