fvicary
04-06-2000, 12:15 PM
I have created a simple database but want the year in front of the autonumber. I don't care how it's done
EX the application number is 1999/0001 and so on. When year 2000 comes around i want it to start automatically at 2000/0001 and keep adding up until 2001 and start all over again.
I have been trying to figure it out for months. Please help
EX the application number is 1999/0001 and so on. When year 2000 comes around i want it to start automatically at 2000/0001 and keep adding up until 2001 and start all over again.
I have been trying to figure it out for months. Please help