1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

Access - Create unique ID combining letters and numbers

Discussion in 'Business Applications' started by paul_carron, Dec 30, 2012.

Thread Status:
Not open for further replies.
  1. paul_carron

    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
     
  2. GelflingLady

    GelflingLady

    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.
     
  3. OBP

    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.
     
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 733,556 other people just like you!

Loading...
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/1082999

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice