New to access ... need help.
I want to create a special quote number in a form, I want the number to autogenerate.
The number is alphanumeric in the form "Q02-01-11"
1)It always starts with Q.
2)The "02" after Q is always the current month (in this case, February).
3)The 01 is sequential (i.e. the next entry would be Q02-02-11 ...)
4)The last number is always the current year (in this case, 2011).
5)The sequetential number restarts at 01 for every new month.
Any help would be great.
My hope is that this number autogenerates in a form and automatically adjusts itself according to month year.
Can this be done?