Sequential Form Field Number Formula

[szag via AccessMonster.com]

I am not sure how to do the following.

We have project numbers that are made up of 3 parts "C" (representing
Customer), "10" (representing last two digits of year), and then a 3 digit
number starting with "000".

My issues is I need a default that looks adds 1 to the last 3 digits. So if
the Project number was C10000 then the default for a new project should be
C10001, C10099 becomes C10100, etc.

 

[Tom van Stiphout]

On Sat, 13 Feb 2010 01:21:54 GMT, "szag via AccessMonster.com"

You can use the often-discussed "DMax+1" solution. You will have no
trouble finding references at groups.google.com or elsewhere.

To format a number with 3 digits, use the Format function.

PLEASE don't use this field as your primary key.

-Tom.
Microsoft Access MVP