Hi can someone help me with the following?
I have a table that has various values that
occur on 1-5 records. I need to allocate a count on each record as to how many so far have this value
i.e
field1 count
a 1
a 2
a 3
b 1
b 2
c 1

I then need to place the count so far against each record in the table ..

anyone assist?