Incrementing...round two

[Greg]

Thanks to Marshall Barton for his efforts....

This is what I am trying to do.

I have a table with the following information (AcctNo&procedure). It is
sorted by AcctNo. After adding two empty columns(Claim&ClaimLine), I want to
insert into those columns values that make the record unique(Perhaps by
button click from a form).

Here is some sample data:

AcctNo Procedure
A 99213
A 34615
B 99243
C 99281
C 70001
C 88000

After insertion, this is what I would like to see:

AcctNo Procedure Claim ClaimLine
A 99213 1 1
A 34615 1 2
B 99243 2 1
C 99281 3 1
C 70001 3 2
C 88000 3 3

Notice the counter adds one for each change in AcctNo to the claim value.
It starts again at 1 and adds one for each new line within a claim until
there is a change in AcctNo

Hope this helps clarify my earlier post. Thanks again Marshall for your
patience.