Autonumber change at year end

[drozbravo]

I am currently trying to set up a database that coordinates project, billing information, and an autonumber for the project number. The current set up is changing on a yearly basis. Job number being i.e. 05-001, 05-002, and so on. Next year it will be 06-001. Is there a way to format the autonumber to pick up on the date change and autonumber accordingly. Thanks for the help.


Drozbravo

 

[SydneyGeek]

You can't do that with Autonumbers -- you will need to create a Text field (ProjectCode) to hold the information. Requires a detailed explanation, a couple of spare fields in your table to keep track of things, a few queries and some code on the main form.

Send a PM with your email and I'll try to help offline.

Denis