TrackMissingAndDuplicates.mdb |
Post Reply |
Author | |
A.D. Tejpal
Microsoft MVP Joined: 30 Jun 2008 Status: Offline Points: 192 |
Post Options
Thanks(0)
Posted: 06 Jul 2008 at 10:44pm |
This sample demonstrates monitoring of sequential values so as to keep track of missing as well as duplicate values. The status form displays the following information (side by side) - (a) Overall Position as existing. (Records where next required sequential value is missing are highlighted. In addition, records carrying duplicate values are also highlighted in different color). (b) Gist of missing sequential values. (c) Gist of duplicate sequential values. Update: The scope has now been expanded so as to cover - (a) String values with formatted numeric suffix. (b) String values with un-formatted numeric suffix. (c) Pure dates. (d) Pure numbers.
|
|
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 |