Numbering

[julz]

I need to number records in a table by a group. ie. Each account number may
have 1 - 5 records. I need them numbered 1, 2, 3, 4, 5, and then the next
account number would start over 1, 2, 3, and then the next etc.
I cannot think this one out. Any help is appreciated. Thanks

 

[Duane Hookom]

There is no order to records in an Access table so 1, 2, 3, 4, and 5 aren't
possible. If you want to number records in some order, you need to be able to
create an expression that identifies the order such as HireDate, alphabetical
by name, ID field value, or whatever.

If you still need assistance, please reply back with actual table and field
names, data types, and sample records with the desired "numbers".