Results 1 to 3 of 3
  1. #1
    4 Star Lounger
    Join Date
    Jun 2001
    Location
    Sacramento, California, USA
    Posts
    491
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Missing autonumbers (WIN 2000 Acc 97)

    Can someone direct me to a good resource that would have algorithms such as the following:

    I have a table with 1000 records.
    The autonumber goes up to 1045.
    This is due to deleted records.

    I need an algorithm that will give me the autonumbers missing between 1 and 1045.

    I appreciate your help.

    Michael Abrams

  2. #2
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: Missing autonumbers (WIN 2000 Acc 97)

    You could create another table and setup 1045 records in it number 1 to 1045. Thne just setup an Unmatched Query" between this new table and your table.
    HTH
    Pat

  3. #3
    4 Star Lounger
    Join Date
    Jun 2001
    Location
    Sacramento, California, USA
    Posts
    491
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Missing autonumbers (WIN 2000 Acc 97)

    Amazing !

    Guess I don't need an algorithm!!!

    Very Much appreciated Pat !!!!!

    Michael

Posting Permissions

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