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

reset id number every year

P: 43
Hi Guys...

Im doing a system and it really make my head ache..i hope somebody help me..

I need to have an id like this "ABCD-07-000001"... I dont know how will I work on that thing.. ABCD always a default character..07 is the last two digit of the year and it should be reset everytime a year change..and the last six digit should be incremented by 1 everytime they add a new record but it should be reset when the year change..please help me i dont have any idea on this..im using access and sql..tanx in advance...
Jan 5 '07 #1
Share this Question
Share on Google+
3 Replies


Expert 5K+
P: 8,435
Hahaha... great timing! :D

There has been a discussion of this very topic the last day or two, in this thread: https://bytes.com/showthread.php?t=584213
Jan 5 '07 #2

P: 43
Hahaha... great timing! :D

There has been a discussion of this very topic the last day or two, in this thread: https://bytes.com/showthread.php?t=584213
first of all thank you so much..but i still confused..im doing this from the scratch..i dont know what are the field in table to be use..thanx in advance..
Jan 5 '07 #3

NeoPa
Expert Mod 15k+
P: 31,186
Unless you tell us what you have a difficulty with then we can't help.
The answers should all be there in the other thread.
Jan 7 '07 #4

Post your reply

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