Sequential numbering when X column repeats records

  • Thread starter Thread starter robpiolink
  • Start date Start date
R

robpiolink

I have a table with 2 columns

Column 1 has records
A
A
A
B
B
C
A
Column 2 needs to have the number of times row one repeats a record.
Something like this
1
2
3
1
2
1

Any formula that will find records on column one and sequentially number
column B depending on amount of records?

Thank you

-RoMo
 
robpiolink,
Give each record a value of one with a calculated bound field in your
query...
GrpCounter : 1

Add GrpCounter to the report section.

Group your report on each letter (in this example), and set
GrpCount Running Sum property to...
Over Group

At each group it will step 1,2,3,4,5, etc..., for each value,
and reset when going to the next Group.
--
hth
Al Campagna
Microsoft Access MVP 2007-2009
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."
 
Back
Top