number series macro

[jumpstartr]

I want to assign a sequential series of numbers, 1,2,...n, to each
member of many sub-categories. I want to do this automatically with a
macro. For example, the numbers assigned to members of sub-category
"A" should begin with 1,2,3,4. However, later on, others will be added
and their numbers must start where the first numbers left off for
Category "A". I thought perhaps if I query the count of members in
each category, I might be able to set a starting and ending number for
each. I'm not good at VBA but will try if macro won't do. Thanks for
any help with this.

 

[Ian]

can you not use the [autonumber] field in the base table?

 

[jumpstartr]

can you not use the [autonumber] field in the base table?

I want to assign a sequential series of numbers, 1,2,...n, to each
member of many sub-categories. I want to do this automatically with a
macro. For example, the numbers assigned to members of sub-category
"A" should begin with 1,2,3,4. However, later on, others will be added
and their numbers must start where the first numbers left off for
Category "A". I thought perhaps if I query the count of members in
each category, I might be able to set a starting and ending number for
each. I'm not good at VBA but will try if macro won't do. Thanks for
any help with this.- Hide quoted text -

- Show quoted text -

I need a different series for each category and now the AN in the base
table shows just one series of numbers for all members instead.

 

[jumpstartr]

can you not use the [autonumber] field in the base table?

Maybe a better way to ask is to explain a little more...

I have 1000+ categories (aka ProductFamilies) to manage at any one
time. At any time new categories are added while others are discarded.
Each year we select the best ProductFamilies to expand. We expand a
favored ProductFamily to between 1-99 new Selections (SelectionID). I
want to assign these new SelectionIDs a sequential number 1,2,3,4,..,
99 within each ProductFamily or category. (The number selected is
always less than 100.) We repeat the selection process anew for each
category, thereby creating Selections within Selections. The number
series starts over each Selection Cycle. The SelectionID (1-99) is
used along with the ProductFamilyID to create the Labeling code,
ProductFamilyID & ProductID.

Not sure if that helps.
Thanks for any help!