V
VBmatta via AccessMonster.com
Hello all
I want to extract or filter data from parent data.I have limited knowledge of
ADO recordsets .
I have a huge amount of data ,i had kept in a single column format.Now i want
to make changes to the data.The data is combination of zero and non zero
values.
What i want to do is define a parameter called event :
Event definition ( with respect to data ) : Event should atleast have four or
more non zero values ,Two events are seperated by six or more number of
zero's ( Continous ) between them and the sum of an event should be greater
than 0.1.
After extracting events from data , Would i be able to store themalong with
their sum , index,average, minimum and maximum.
So my output will be the values of events in a column with their sum etc.. in
next column's or in the same column but with specification
Can you help me in this regard
Thanking you
Yours sincerely
Arenden
PS:
Data Format
8/1/1948 0
0
0
0
0
0
0
0
0
0
8/5/1948 0
0.01
0.02
0.01
0.26
0.49
0.06
0.11
I want to extract or filter data from parent data.I have limited knowledge of
ADO recordsets .
I have a huge amount of data ,i had kept in a single column format.Now i want
to make changes to the data.The data is combination of zero and non zero
values.
What i want to do is define a parameter called event :
Event definition ( with respect to data ) : Event should atleast have four or
more non zero values ,Two events are seperated by six or more number of
zero's ( Continous ) between them and the sum of an event should be greater
than 0.1.
After extracting events from data , Would i be able to store themalong with
their sum , index,average, minimum and maximum.
So my output will be the values of events in a column with their sum etc.. in
next column's or in the same column but with specification
Can you help me in this regard
Thanking you
Yours sincerely
Arenden
PS:
Data Format
8/1/1948 0
0
0
0
0
0
0
0
0
0
8/5/1948 0
0.01
0.02
0.01
0.26
0.49
0.06
0.11