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 Nov 2018 at 8:18am

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

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 >>: -  


Email: -

Print Page | Close Window