Print Page | Close Window


Printed From: Roger's Access Library
Category: Other Download Libraries
Forum Name: Tejpal, A.D.
Forum Description: A.D. Tejpal's Library
Printed Date: 19 Jan 2021 at 12:47am
Software Version: Web Wiz Forums 12.03 -

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

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.

    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 >>: - uploads/37/


Email: -

Print Page | Close Window

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