Hi @ all,
I experience a little problem by defining ranks to certain value's in a
table. So far I counted the records within an recordset group through the sql
statement COUNT. Thus similar records will be cummulated and the other will
get the count 0. In the following the problem is listed as an example.
Example:
Original Table:
ID Value
123 4
123 4
123 5
123 6
321 2
321 2
The Outcome should be:
ID Value1 Rank
123 4 1
123 4 2
123 5 3
123 6 4
321 2 1
321 2 2
Any help is highly apreciated. Thank you very much in advance.
Yours Sincerely
Malte
|
Similar Threads
