How to set autonumber with the current Year as Initial value

[LionelSpratt]

Hi guys......I hope this is easy

As explained in the Title, I want access to generate for me an autonumber, but with the current year as initial value. ( To give new hired employees a unique number)


For example, we are now in 2013
If there a new hire, that employee is going to get a unique number 2013001
The next new hire, will get 2013002
and so on

I know how to append a table to set the initial value, but this means, that next year I will have to append a new table again to set the initial value to 2014.
I want access to do this automatically for me, so that next year a new hire will get the unique number of 2014001, the next one will be 2014002 etc\

Is this possible ?

Please be very careful when explaining, since I'm an access novice.

[orange]

You do not want an autonumber for this purpose.
You should research Normalization and atomic data.

There is a good article at http://forums.aspfree.com/attachment...2&d=1201055452

Good luck.

[LionelSpratt]

You do not want an autonumber for this purpose.
You should research Normalization and atomic data.

There is a good article at http://forums.aspfree.com/attachment...2&d=1201055452

Good luck.

Hmm.....not very helpful actually
Is it something too difficult to accomplish ?

[pbaldy]

See if Jason's FAQ helps:

http://www.baldyweb.com/CustomAutonumber.htm

[orange]

I thought a direct statement -- you don't want to do that was direct.
Did you read and understand the info in my response at
http://forums.aspfree.com/attachment...2&d=1201055452

I see Paul has given you a link also, and here's another.
http://www.utteraccess.com/wiki/index.php/Autonumbers

Please read the info to get the background and rationale based on the experiences of others.

As for you previous question

Is this possible ?

Possible, but not necessarily with autonumber -- since autonumber is guaranteed only to be UNIQUE-------not sequential; may be Positive or Negative.

And it isn't always well-behaved. In those cases see Allen Browne's article
http://allenbrowne.com/ser-40.html

Good luck with your project.