Well maybe I can rephrase what I'm trying to do. I would like to know for each RPID, not only how many records are there with that ID but give each record with that ID a sequential number starting at 1 and increasing by 1. At each change in ID, reset it to 1 and begin again. I don't need them...
Sorry about that.
taxmanrick,
You didn't answer my question about the sequence/order. Records are like marbles in a bucket. There is no order. If you want to sequence them, you need to provide the specifications as to which record gets assigned 1 vs 2. If your data doesn't provide this order...
The change in RPID is what I am using as a flag to stop and start counting. The Prop Class is just information. So I want to count from one and increment by one every record that has the same RPID and reset the counter to one at each new RPID
Access 2013
I have a table that includes multiple records per account number. I would like to create a field that numbers each record so that every record has a number starting at 1 and increasing by 1 for each record for that account number. For example:
Original Table
RPID-----PropClass...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.