Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2006

    auto number with leading zeros

    I need my database form to programmatically go to the next available number when a check box is set to "yes". This next number in sequence should be five digits, with leading zeros. I'm stumped.

  2. #2
    Join Date
    Nov 2004
    out on a limb
    Sounds like you are trying to impose a meaning on an autonumber field.....

    within most db engines you can't do that. I suppose you could put a constraint to check the autonumber field was in range 1..99999.

    you could handle the leading zeros by formatting in your front end / user interface

    BTW what forn end are you using, waht data / SQL engien are you using
    I'd rather be riding on the Tiger 800 or the Norton

Posting Permissions

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