Results 1 to 2 of 2
  1. 10-03-2007, 03:05 AM #1
    J A F F A
    J A F F A is offline Novice
    Join Date
    Oct 2007
    Posts
    1

    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?
    Reply With Quote Reply With Quote
  2. 10-03-2007, 10:30 AM #2
    jya
    jya is offline Competent Performer
    Windows XP Access 2007
    Join Date
    Sep 2007
    Location
    Chicagoland
    Posts
    109
    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
    Reply With Quote Reply With Quote
Please reply to this thread with any new information or opinions.
« Previous Thread | Next Thread »

Similar Threads

  1. Customizing the Autonumber field
    By wasim_sono in forum Access
    Replies: 3
    Last Post: 10-24-2014, 03:00 PM
  2. duplicate autonumber
    By rayc in forum Access
    Replies: 5
    Last Post: 06-19-2013, 07:50 AM
  3. Problems with autonumber field in a form
    By admaldo in forum Forms
    Replies: 0
    Last Post: 02-25-2008, 11:09 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules

Other Forums: Microsoft Office Forums