Print Page | Close Window

Query_FindClusters

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=578
Printed Date: 13 Dec 2017 at 5:34pm


Topic: Query_FindClusters
Posted By: A.D. Tejpal
Subject: Query_FindClusters
Date Posted: 20 Nov 2011 at 11:41pm

Query_FindClusters
Explanatory Notes

    This sample db demonstrates identification of clusters in value series as per given maximum allowed spacing between adjacent elements of a cluster. For this, sorted values are subjected to sliding comparison via unequal self outer join.

    Original data is displayed in the subform at left. Based upon user selection of SeriesID and maximum allowed spacing between adjacent elements of a cluster, the values qualifying as members of various clusters are displayed in the subform at right. Start value for each cluster is also displayed in a separate column.

    Simultaneously, matching value elements in in the subform at left get highlighted in distinct color.

Version: Access 2000 File Format

References: DAO 3.6

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


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

Email: mailto:adtejpal@gmail.com - adtejpal@gmail.com



Print Page | Close Window