Combining year field and autonumber

[Coni Fields]

I need the code for starting the year at 1 October and
resetting autonumber back to 001 so it would read 2004001
up until 30 sept and 1 oct it would change to 2005001.
Thanks

 

[John Vinson]

I need the code for starting the year at 1 October and
resetting autonumber back to 001 so it would read 2004001
up until 30 sept and 1 oct it would change to 2005001.
Thanks

You cannot do this with an Autonumber. You'll need to maintain the
number yourself in VBA code. This code can become fairly complex if
it's a multiuser system - I use some copyrighted code from the Access
Developer's Handbook so I can't post it here, but look in Google for
"Access Custom Counter" - there are several examples around.