Auto number a field

[jenncivello]

I have a table that has a number field that increments the number +1 for every new record that is added. But I would like it to look like this ITCC12-001 then ITCC12-002 etc.



Can you please let me know if this is easy enough to do, as I am a basic access user.

Thank you

[alansidman]

In your table, in the design view, set the data type to AutoNumber. In the properties, set the format to "ITCC12-"#. This should increment the number and give you the prefix ITCC-12.

Alan

[RayMilhon]

To get the format you specified use Alans sample with 1 minor change

"ITCC12-"000