reset autonumber each year when start begining of the year

[tweetyng]

hi,
i have a field name ID (autonumber) and date, how do I reset the autonumber to 1 when new year start.
Examples:

ID Date
1 01/01/07
2 07/15/07
3 12/24/07
4 12/31/07
1 01/01/08
2 02/05/08
3 09/01/08
and so on.
please help

TN (USA). I'm using Windows XP, Access 2003, Crystal Reports 11 and SQL Server

 

[Remou]

Autonumbers do not work like that. If you need a number that starts at one for each new year, you should create one.

See the 7th commandment:

http://www.mvps.org/access/tencommandments.htm

From: Autonumber
thread700-1225179