By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,497 Members | 2,113 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,497 IT Pros & Developers. It's quick & easy.

reset numbers

P: 1
how to reset number back to 000001 base on months ( on every 1st of month )
Jan 31 '08 #1
Share this Question
Share on Google+
1 Reply


MMcCarthy
Expert Mod 10K+
P: 14,534
how to reset number back to 000001 base on months ( on every 1st of month )
Firstly, this won't be possible if the field is a primary key. However, assuming its not you will have to set this programatically using VBA. How this is triggered will depend on your database.
Feb 5 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.