How do I create a autonumber with format EC-0000 in access?

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

Guest

I want to create a number in the format of EC-XXXX (X represents number) that
increases by one with each new record.
 
Hello,
Within your table (= ones or form = more) in the format property of the ID
field : "EC-"0 and that's done.
Bye,
 
If it's always going to be EC-, then simply set the field's format to "EC-"#

If the EC part varies, then you should have 2 separate fields. It's actually
a violation of database normalization principles to store two separate
values in a single field.
 
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

How do I get Access to differentiate capital and lower case letter 2
Concatenate Date and Number field for Append Query 0
autonumber queestion 3
Access 2007 autonumber oddity 28
Create custom autonumber field 5
DMAX with Criteria 1
Formatting a # to auto + 1 when adding new info- not autonumber th 2
Autonumbers 5

Back
Top