Results 1 to 4 of 4
  1. #1
    Join Date
    Feb 2004
    Posts
    7

    Unanswered: Autonumber Custom Format

    Hi all.......I'M Using Ms Access to develope a db...which I want to set an

    autonumber format like this "FAMAOR-YY-XXXXX"....The YY = Year and

    the xxxxx = autonumber...and the example of generate autonumber

    should be like this "FAMAOR0200001".....can anybody

    tell me how to do this

  2. #2
    Join Date
    Oct 2001
    Location
    Chicago
    Posts
    440
    You could have another text field in the table that has a default value of "FAMAOR"+Format(Date(),"yy").

    Then concatenate both in a query to achieve the format that you want.

  3. #3
    Join Date
    Feb 2004
    Posts
    7
    Hello ROCKy......Thanx for reply but can tell a little bit more on how to
    do this coz I'm kindda new in this whole db thing......may god bless you for your help

  4. #4
    Join Date
    Oct 2001
    Location
    Chicago
    Posts
    440
    see REVISED attached db
    Attached Files Attached Files
    Last edited by Rockey; 02-02-04 at 20:07.

Posting Permissions

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