Autonumber

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Can you format/code an autonumber which starts with text and ends with numbers.

eg. TOOL#124
 
Can you format/code an autonumber which starts with text and ends with numbers.

eg. TOOL#124
Click to expand...

No.
But you can concatenate an auto number with text.
="TOOL#" & [AutoNumberFieldName]

as long as you realize that an AutoNumber need only be unique, not
necessarily consecutive. If the actual number has a meaningful purpose
(other than it's uniqueness), don't use an autonumber.
 
Thanks that works great

fredg said:
Can you format/code an autonumber which starts with text and ends with numbers.

eg. TOOL#124
Click to expand...

No.
But you can concatenate an auto number with text.
="TOOL#" & [AutoNumberFieldName]

as long as you realize that an AutoNumber need only be unique, not
necessarily consecutive. If the actual number has a meaningful purpose
(other than it's uniqueness), don't use an autonumber.
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access 2010 query for 3 tables 0
Autonumber field with semi-static text? 4
Autonumbering Query 1
How can I keep the AutoNumber from skipping numbers? 3
Autonumber Macro 3
Autonumber 2
Access Autonumber Feature 3
autonumbers 3

Back
Top