Results 1 to 5 of 5
  1. #1
    Join Date
    Sep 2001
    Posts
    175

    Question Unanswered: Missing system generated auto. numbers

    On a form I have an Invoice No. Field which is a system generated sequence number (AutoNumber) but for some reason it sometimes skips numbers e.g. I would have invoice nos. 1-20 then 27-50.

    Would would cause the numbers to skip????

  2. #2
    Join Date
    Dec 2003
    Posts
    454
    Did you delete some of rows?

  3. #3
    Join Date
    Sep 2001
    Posts
    175
    According to the user - No!!

  4. #4
    Join Date
    Dec 2003
    Posts
    454
    Did you check if there are some invoices missing in the table?

  5. #5
    Join Date
    Sep 2001
    Posts
    175
    No invoices missing - just the sequence problem

Posting Permissions

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