Access 2007 Auto Number?

[katie365]

Hi,



For my exam I have to learn how to do auto numbers in access but I do not know how to do them, i have been researching them on the internet but i still don't understand it, i have also attempted to add it to a database but still its not working!

Can somone help my please help me with this?

Ok so what I have is a Form and I need to generate a student ID (I already have this field by the way) for the students. The student ID must consist of the first three letters of their surname and a sequential number one higher than the last.So how can I do this please....help me!!!

thanks!

[RuralGuy]

Maybe this link will help: http://www.baldyweb.com/CustomAutonumber.htm

[katie365]

Sorry but I don't understand that website you gave me, I need step by step instructions, I am a beginner at this....so can anyone else help me out please???

[orange]

What part of the information at Allan's link did you not understand?

You request

The student ID must consist of the first three letters of their surname and a sequential number one higher than the last.

As the Baldyweb site explains

The point is an AutoNumber is intended to be an AutoNumber, not a SequentialNumber. It's intended to provide a system-visible unique record identifier, not a user-visible one.

and

You don't want an AutoNumber. The main problems with using an AutoNumber field as a user-visible field:

• You are not going to be able to guarantee the number remains sequential.

[katie365]

Ok thanks!