AutoNumber

[GK]

Hello,

Is it possible to have a AutoNumber Field that start with letters, then the
sequential numbers like "GK1","GK2" ?

Any advice would be appreciated!

GK

 

[Gina Whipp]

You cannot insert letters in the AutoNumber field, however in the format
sections under properties of the control you can type ="GK" &
[NameOfYouAutoNumberField]

Make sure you change the field name because you will recieve an error
message if you don't. Also, this is great if the letters to don't ever
change and can be used on forms, reports and quieries.

 

[Duane Hookom]

I would create a separate field with the value "GK". If the value will
always be "GK" then you don't need a field.

 

[TC]

Further to what the others have said, be aware that autonumbers can have
gaps (eg. 1, 2, 6, 7, ...). There is no guarantee that they are
monotonically increasing (sequential wuith no gaps). To see this happening,
try the following. Create a table with an autonumber field, & another field.
Open the table. Type something in the other field but *do not save the
record*. Now press Escape a few times to cancel the (unsaved) new record.
Now repeat that process a few times. Now do it again, but this time save the
record. Oops! The table now has just 1 record, but the autonumber is not 1.

HTH,
TC