Prev: Credit Debit Account (Report) for Individual customers
Next: Report with Monthly rows, Yearly columns & 3 pieces of data per mo
From: cliff on 29 Jun 2008 21:55
I have the following data

sr no1. no2. no.3 no.4 no.5 no.6 10hot 10cold
1 1 8 11 25 30 32
2 4 8 19 28 30 45
3 7 14 20 31 35 39
4 4 12 15 20 43 48
5 9 16 21 22 26 36
6 5 17 28 29 31 47
7 20 13 15 30 33 32
8 11 15 16 25 26 49
9 25 32 36 39 40 44
10 5 6 17 20 27 43
11 35 37 38 40 45 47 - 2
12 25 27 28 38 39 45 2 -
13 8 11 15 32 46 18 1 2


10 hot and 10 cold are calcuated fields based on previous 10 records

I have coduct analysis to check how many nos from 11 record onwards are from
previous 10 records i.e, 1 to 10 for 11, 2 to 11 for 12 records and so on

10hot nos are calucated from 10 previous records, they are basically most
repeated nos i.e., ten 10 most repeated nos and revserse for 10cold nos

i could calculate for one row at a time by series of union, merge and match
and unmatched query's and update the field with tthe result manually one row
at a time . How can I do it automatically


 | 
Pages: 1
Prev: Credit Debit Account (Report) for Individual customers
Next: Report with Monthly rows, Yearly columns & 3 pieces of data per mo