Reset number at the beginning of each year

March 15, 200718 yr

Dear All

I need to create a record numbering system which combines Year + Code + Number. The number increases by 1 for each new record created, and resets the number to 0 at the beginning of each year, eg:

2007-ABB-01

2007-ABB-02

2008-ABB-01

2008-ABB-02

My query is how to have the Number automatically reset to 0 at the beginning of each new Year.

I would appreciate any help on this; I have searched the forum but have not retrieved quite the right answers.

Thanks

Anne

March 16, 200718 yr

See the following threads. Pay particular details to the warnings about using this as a display only number, not the true serial number.

Thread 1

Fenton's Post

If you ever get FM Developer, you can make use of this thread.

Custom Function Use

March 16, 200718 yr

Author

Thanks - I'm sure one of these will do the trick.

The only purpose for creating these numbers is for a hard copy shelf numbering system. I will be retaining a separate unique serial ID number field independently for relational purposes.

thank you.

Anne