Hello
I've designed a database for the job numbers at my company. However instead of just the normal 'autocount' ie 1, 2, 3 for the jobs. I would idealy like a prefix of 02/001, 02/ 002... etc. As 02 = year 2002.
I would of thought this was pretty simple, but it does not appear so!
If anyone has any advice, it would be greatfuly recieved!
Many Thanks
I've designed a database for the job numbers at my company. However instead of just the normal 'autocount' ie 1, 2, 3 for the jobs. I would idealy like a prefix of 02/001, 02/ 002... etc. As 02 = year 2002.
I would of thought this was pretty simple, but it does not appear so!
If anyone has any advice, it would be greatfuly recieved!
Many Thanks