|
|
|
#1
10-03-2007, 01:05 AM
|
|||
|
|||
AUTONUMBER
I am currentky creating a database to track manpower tasking. Each task has a unique number to identify it however, to stop the numbers getting too high the numbers start again at 1 at the end of each financial year.
Is there any way of setting autonumber so it starts at 1 at the beggining of each financial year? 
|
|
#2
10-03-2007, 08:30 AM
|
|||
|
|||
|
Not sure what you are using the autonumber field for, but I see that there is plenty of information on "resetting autonumber" on Google. One link I came across...
http://www.tek-tips.com/viewthread.c...1235744&page=1
|
|
| Bookmarks |
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Problems with autonumber field in a form | admaldo | Forms | 0 | 02-25-2008 08:09 AM |
| Customizing the Autonumber field | wasim_sono | Access | 1 | 09-01-2006 05:27 AM |
| duplicate autonumber | rayc | Access | 0 | 01-16-2006 06:57 AM |
 do all primary keys use autonumber
|
k | Database Design | 4 | 11-22-2005 06:32 AM |
Windows XP 
Access 2007 (version 12.0)
Linear Mode
