AutoNumbering in Access

Results 1 to 3 of 3

Thread: AutoNumbering in Access

  1. #1
    Fion Guest

    Default AutoNumbering in Access

    MS Access has an auto-numbering feature that generates an incremental number for each record. But it is the form of only numbersie 1,2, to get it to generate incremental numbers with a certain format ie PO001,PO002...etc?

  2. #2
    David Highlander Guest

    Default RE: AutoNumbering in Access

    I looked through my Access book and as far as I can tell there is no way to format the AutoNumber.<BR><BR>Sorry.

  3. #3
    Join Date
    Dec 1969

    Default RE: AutoNumbering in Access

    While you can&#039t put characters in the autoindex column, you<BR>could create a varcahr column that would concantenate "P" +<BR>Convert(Varchar,(contents of autoindex column))

Posting Permissions

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