Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Assign Auto Id
- Thread starter pthakar
- Start date
This is very simple to do. Go into your table in design view, and go to the properties sheet at the bottom for your autonumber field...type this into your format property -
"OC"000000 This forces a 6-digit number to concatenate to the string literal OC to be read as OC000001, OC000002, etc.
"OC"000000 This forces a 6-digit number to concatenate to the string literal OC to be read as OC000001, OC000002, etc.
- Status
Similar threads
- Locked
- Question
