Incrementing Value

[wkim623]

Hi,

I'm trying to increment the last number of our serial number. Here is the situation,

Let's say the order calls for 15 items that are the same and I need to make 15 labels that will increment up to 15 because the order calls for 15 items. So can I somehow make Access keep incrementing until the no.15 based on the order qty from our database? Here is our format, (?) shows where I'm stumped.

=Right([WANTDATE],2]+LEFT([WANTDATE])+"-"RIGHT([SALESID],5)+"-"+RIGHT([WORKORDERID])+"-"+(?)

End result
0308-25522-25225-

desired result
0308-25522-25225-1
0308-25522-25225-2
0308-25522-25225-3
0308-25522-25225-4
0308-25522-25225-5
.
.
.
.
.
0308-25522-25225-15

Thanks for your help in advance!

 

[PaulBricker]

If your orders are grouped then you can do this.

Add a textbox to your report in the detail section. Set it's Control Source to =1, Set it's Running Sum value to Over Group and set it's visible property to No. Then in your other formula replace your (?) with the name of your running sum textbox. This will only work if your orders are grouped.

Paul

 

[wkim623]

Thanks for your input, it worked!