Add 1 to Serial Number

[Reggie]

It's kicking my butt. All I want to do is add 1 to each new records I add
to my table using a form. The serial number is in the form 0001, 0002, 0003
etc, and increments for each record. If I enter the value in the table
directly it retains the leading zero's however if I use the dmax function
and add one to it it's store as 1, 2, 3 etc. I'm stumped. Can I do this as
a default value in the table? Any advice is appreciated. Thanks in advance
for you time!

--
Reggie

www.smittysinet.com
----------

[Rick Brandt]

"Reggie" <no**********@smittysinet.com> wrote in message
news:vc********************@comcast.com...

It's kicking my butt. All I want to do is add 1 to each new records I add
to my table using a form. The serial number is in the form 0001, 0002, 0003
etc, and increments for each record. If I enter the value in the table
directly it retains the leading zero's however if I use the dmax function
and add one to it it's store as 1, 2, 3 etc. I'm stumped. Can I do this as
a default value in the table? Any advice is appreciated. Thanks in advance
for you time!

Just store it as a number (in a numeric field) and use a format to *display* the
leading zeros. Otherwise use your DMax() but wrap it in a Format() function to
add the leading zeros on before storing it.
--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com

[Reggie]

Got it. Thanks for the quick response.

--
Reggie

www.smittysinet.com
----------
"Rick Brandt" <ri*********@hotmail.com> wrote in message
news:2i************@uni-berlin.de...

"Reggie" <no**********@smittysinet.com> wrote in message
news:vc********************@comcast.com...

It's kicking my butt. All I want to do is add 1 to each new records I add to my table using a form. The serial number is in the form 0001, 0002, 0003 etc, and increments for each record. If I enter the value in the table
directly it retains the leading zero's however if I use the dmax function and add one to it it's store as 1, 2, 3 etc. I'm stumped. Can I do this as a default value in the table? Any advice is appreciated. Thanks in advance for you time!
Just store it as a number (in a numeric field) and use a format to

*display* the leading zeros. Otherwise use your DMax() but wrap it in a Format() function to add the leading zeros on before storing it.
--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com