How do you create a field, which will automatically assign a number to the record? I wish to have a number which will also include the year for example “1/2006”. Also once the year has ended it automatically changes the year and starts from the number 1 again e.g. 1/2007 and so on.
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 IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Incremental count
- Thread starter mpsDA
- Start date
This may depend on a few things, such as the number of users. Have you seen, for example:
Why AutoNumber shouldn't be used in MultiUser databases (And How to ge the Unique Number)
faq700-184
For a much simpler set up, you could use DMax.
If you mean when entering data in a table, rather than a form, I do not think this is possible.
Why AutoNumber shouldn't be used in MultiUser databases (And How to ge the Unique Number)
faq700-184
For a much simpler set up, you could use DMax.
If you mean when entering data in a table, rather than a form, I do not think this is possible.
- Thread starter
- #3
- Status
Similar threads
- Locked
- Question
- Locked
- Question