Print Page | Close Window

Query_GrpSequentialsAndMissing

Printed From: Roger's Access Library
Category: Other Download Libraries
Forum Name: Tejpal, A.D.
Forum Description: A.D. Tejpal's Library
URL: www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=556
Printed Date: 28 Mar 2024 at 3:09pm
Software Version: Web Wiz Forums 12.03 - http://www.webwizforums.com


Topic: Query_GrpSequentialsAndMissing
Posted By: A.D. Tejpal
Subject: Query_GrpSequentialsAndMissing
Date Posted: 27 Jan 2011 at 8:49am

Query_GrpSequentialsAndMissing
Explanatory Notes:

    This sample db demonstrates identification of data blocks as well as missing portions in a sequential series. Three types of source data are covered:

    (a) Number series.
    (b) Alpha-numeric series.
    (c) Date series.

    Subform on left shows all records, duly highlighting the start of each new block of sequential series. Subform at right depicts group-wise gist (for each PersonID) of sequential blocks as well as missing portions, duly indicating the start and end values for each set. Missing blocks are highlighted in light grey.

    Note:
    For identifying the start and end values for available as well as missing blocks in the given sequential series, an interesting technique has been used in this sample db, eliminating the need for any driver or temporary table. Instead, sliding comparison with projected next and previous values has been adopted through self joins based upon source data.

Version: Access 2000 file format.

References: Nothing extra.

Download >>:  http://www.rogersaccesslibrary.com/forum/uploads/37/Query_GrpSequentialsAndMissing.zip - uploads/37/Query_GrpSequentialsAndMissing.zip
 
 
 


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

Email: mailto:adtejpal@gmail.com - adtejpal@gmail.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