Jump to content

Serial number

Recommended Posts

Guest Sarah

I am carrying out a project to finalize a project for the college which consists of the following.

An automatic serial number of two groups with numbers with a space in the middle of the third digit (ex: 159 023)

ex: 159 023
159 024
159 025

Thanks for the help.

Link to post
Share on other sites
  • Replies 2
  • Created
  • Last Reply

Top Posters In This Topic

  • Newbies
Posted (edited)

If you are starting this database from scratch, set your Primary Key (type number) to a serial number (on creation) starting at 159 000 (or whatever starting number you need). From then on each new serial number will have that space between the first 3 digits and the last 3 digits. If you already have many records,  create a calculation (number) field with this definition:

Left ( yourSerialNumberField  ; 3 ) & " " & Right (yourSerialNumberField ; 3 )

You can use this second field with a space between the first 3 and last 3 for your project.

Edited by Al Quimby
Link to post
Share on other sites
  • 2 weeks later...

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...

Important Information

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