Roger's Access Library Homepage
Forum Home Forum Home > Other Download Libraries > MS Access MVP Libraries > Tejpal, A.D.
  New Posts New Posts RSS Feed - Query_GrpSequentialsAndMissing
  FAQ FAQ  Forum Search   Events   Register Register  Login Login


Please consider donating $1 per sample downloaded, (find out why here)

Query_GrpSequentialsAndMissing

 Post Reply Post Reply
Author
Message
A.D. Tejpal View Drop Down
Microsoft MVP
Microsoft MVP


Joined: 30 Jun 2008
Status: Offline
Points: 192
Post Options Post Options   Thanks (0) Thanks(0)   Quote A.D. Tejpal Quote  Post ReplyReply Direct Link To This Post Topic: Query_GrpSequentialsAndMissing
    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.

 
 
 
--

Email: adtejpal@gmail.com
Back to Top
Sponsored Links


Back to Top
 Post Reply Post Reply
  Share Topic   

Forum Jump Forum Permissions View Drop Down