Access - Create unique ID combining letters and numbers

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

paul_carron

Thread Starter
Joined
Oct 15, 2006
Messages
207
Hi,

Help! I have to show a group of school kids how to do this but I haven't used Access in years so don't know how to do it myself :s

For an Access project I need to be able to generate a unique student ID, which combines letters from the students name with a sequential number that is always one more than the highest currently in use. I have a forename field so I plan on using the first two letters of the forename plus a unique number. Is it possible to auto ID this?

Any advice would be appreciated.
Paul
 
Joined
Jan 1, 2013
Messages
17
Off the top of my head I can't think of one. My suggestion would be to create a field that concatenates the first two letters from the forename field with an autonumber field. The autonumber field will give you your sequential numbers and the concatenate field will give your unique identifiers.
 

OBP

Joined
Mar 8, 2005
Messages
19,895
GelflingLady's advice is good.
However it depends on whether you need to store the value or just display it.
 
Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 807,865 other people just like you!

Latest posts

Staff online

Top