Results 1 to 4 of 4

Thread: AutoNumber

  1. #1
    Join Date
    Oct 2003
    Posts
    45

    Unanswered: AutoNumber

    how can I code an autoNumer for a table field instead of using the builtin autonumber, I mean A standard Numbering format (like: Year.autonumber - 200300001-200300002-2000300003-200300004....)?

  2. #2
    Join Date
    Sep 2003
    Location
    MI
    Posts
    3,713
    Create a table with a column for the next unique number ...

  3. #3
    Join Date
    Oct 2003
    Posts
    45
    Thanks, In more details "Please", how can I do It with a static number of digits ( 5 digits:00001,00002,00003....) the 5th digit always increment until it reaches 10 then the 4th and the 5th digit increment (00010,00011,.....)?

  4. #4
    Join Date
    Sep 2003
    Location
    MI
    Posts
    3,713
    That's a format issue ... Format(MyNumber,"00000")

Posting Permissions

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