autonumber

red91

Registered User.
Local time
Today, 11:08
Joined
May 13, 2002
Messages
18
Is it possible to start auto number at a given number? Also I have two different types of data that I will track by different tracking numbers, is it possible to denote an auto number with a leter such as E or I? Thanks.
 
Check the archives for ways to start autonumber at a predetermined place, or *surprise* Access Help actually has a topic on it.

It is possible to make your primary key an autonumber+ a text field. You cannot make them in the same field however, nor should you try.
Be aware that your data will do this:
E47, E48, D49, E50...
not:
E47, E48, D47, E49.



[This message has been edited by David R (edited 05-16-2002).]
 

Users who are viewing this thread

Back
Top Bottom