Special autonumber for table in office XP

[fernandezduk]

Hi,
firstly thanks.

I have a problem. I want an field ID to be a special number e.g./

2003001 (year and then three digits.)
This has to be an auto number and must increment every time a new record is started on this table.

Is there a way to do this I am not fussed if it is not an Auto number and not the primary Key either. Any way this can be done is appreciated.

I tried to setup the default value to be =year(date())
but this only gives me the number not the increment.

Help is appreciated. Thanks.

DAVE

 

[MichaelRed]

faq700-184




MichaelRed
m.red@att.net

Searching for employment in all the wrong places

 

[fernandezduk]

WOW Thanks man. Just what I needed. It will take some time to look into this as there is loads of code.

WOW again thanks

DAVE