From: mattc66 via AccessMonster.com on
That worked -Thanks

Marshall Barton wrote:
> rs.SerialNum = Serial & "-" & Format(Qty, "000")
>
>BUT! You should not combine two values into a single field
>(it's a Normaliation Rule). Instead, you shoud use two
>fields, one for the serial string and another for the
>sequential number. Also helpful if you should ever need to
>add more numbers to the same serial. When if comes time to
>display the combined string to users, just use a text box
>with an expression like the above.
>>The below code does almost what I need. With one issue. I want the sequence
>>number to be 3 digits that include leading zeros. So if it's 40 it would read
>[quoted text clipped - 56 lines]
>>>
>>>Matt

--
Matt Campbell
mattc (at) saunatec [dot] com

Message posted via http://www.accessmonster.com