Data Category Counter

[dim1962]

Hi All,

I have a table with 2 fields ID and Data (please see attachment T1)

In a form based on this table I like to add a new field named counter.
I need a code to build this counter which practically will count how many data I have with the same value starting all the time from 1
In this example I have 2 x A, 3 x B 1 x C, so the form I like to show (please see T2)

So if we’ll order (A-Z} by Data will have like in T3

So again, each time when data change the counter will restart from 1 depending ID order.
Please, can somebody help me?

Thanks

 

[John Big Booty]

This thread and sample DB therein may provide an answer to your question.