Reset number at the beginning of each year

[AnneES]

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

[mr_vodka]

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

[AnneES]

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