dtsparky Posted April 12, 2007 Share Posted April 12, 2007 How can I automaticaly create a record ID that has the last 2 digits of the current year followed by sequential numbering that updates itself to begin back at number 1 when the new year begins. Example: 0701 0702 0703... Next year the records would begin to number themselves: 0801 0802 0803... Probably simple for most of you, but I am having a hard time. Thank you Link to comment Share on other sites More sharing options...
mr_vodka Posted April 12, 2007 Share Posted April 12, 2007 See this thread and all the links referenced in it. Also heed all the warnings. Thread on restarting incremental numbers on a yearly basis Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 6195 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now