Jump to content

Auto Serial Number question


This topic is 8566 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies

I am trying to assign serial numbers to a database, with one small difference. I would like to put a text suffix in the front of the number.

For example I have once field with a name (about 6 different names). When it creates the serial number I want to take the first letter from the name and put it in front of the serial number.

please help

Link to comment
Share on other sites

Create a second field that is a text calculation field. I'll call it User_Serial. I'm assuming that the name field is called Name and the serial number field is called Serial. The calculation would be as follows:

Left( Name, 1 ) & Serial

Chuck

Link to comment
Share on other sites

This topic is 8566 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.