Prefix to auto number

barrowfordred

Registered User.
Local time
Today, 20:09
Joined
Dec 9, 2005
Messages
11
I have a database with a field called "Drawing Number".
I can set it up so that the prefix "STD." always appears and then I type in the relevant number.
BUT I cannot figure out how to set up autonumber so that the "STD." appears and then the auto number is added????
 
Autonumber is just that. You can always concatonate them when you need them however. "STD" & cstr([autonumbercolumn])
 

Users who are viewing this thread

Back
Top Bottom