Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2009

    Unanswered: Insert sequential number


    We have created a database for our help desk and one table is an asset database. The data from a spreadsheet was imported into the database as it's historic. The problem is when new assets have to be added to the database. I have a field called ID but I have to manually add the data to the Assets table (which is linked) so the form can pick up the current information. Because the data was imported, I was unable to make the datatype for ID an autonumber. I need help on opening a new form and the next number in the sequence is filled in. Thanks to anyone who can help me with this.

  2. #2
    Join Date
    Jun 2007
    Maitland NSW,Australia
    Use the MAX function to find the last ID then add 1 to this number for your next number

Posting Permissions

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