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

P

papsi

I want to create a number in the format of EC-XXXX (X represents number) that
increases by one with each new record.
 
P

Phil

Hello,
Within your table (= ones or form = more) in the format property of the ID
field : "EC-"0 and that's done.
Bye,
 
D

Douglas J. Steele

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.
 
Top