Query_GrpSequentialsAndMissing |
Post Reply |
Author | |
A.D. Tejpal
Microsoft MVP Joined: 30 Jun 2008 Status: Offline Points: 192 |
Post Options
Thanks(0)
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. 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: Version: Access 2000 file format. Download >>: uploads/37/Query_GrpSequentialsAndMissing.zip
|
|
Sponsored Links | Want a good read? Try The Summer of His Life (available on Amazon!) |
Post Reply | |
Tweet
|
Forum Jump | Forum Permissions You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum |