Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Automatic numbering in Access 2000

Discussion in 'Information Technology' started by Woody, Nov 9, 2005.

  1. Woody

    Woody
    Expand Collapse
    Guest

    I have costructed a database using Access 2000 and one of the fileds utilises
    automatic numbering. This is working fine, except when searching through the
    records already entered, they do not necessarily appear sequentially. What
    can I do to ensure all records when manually searched through in the Form
    View appear in numerical order?
     
  2. Loading...

    Similar Threads Forum Date
    Shabad Numbering System New to Sikhism Dec 1, 2015

  3. Rick Brandt

    Rick Brandt
    Expand Collapse
    Guest

    Woody wrote:
    > I have costructed a database using Access 2000 and one of the fileds
    > utilises automatic numbering. This is working fine, except when
    > searching through the records already entered, they do not
    > necessarily appear sequentially. What can I do to ensure all records
    > when manually searched through in the Form View appear in numerical
    > order?


    Apply an explicit sort on that field in your form or in a query that your form
    is bound to.

    --
    I don't check the Email account attached
    to this message. Send instead to...
    RBrandt at Hunter dot com
     
  4. Joseph Meehan

    Joseph Meehan
    Expand Collapse
    Guest

    Woody wrote:
    >I have costructed a database using Access 2000 and one of the fileds
    > utilises automatic numbering. This is working fine, except when
    > searching through the records already entered, they do not
    > necessarily appear sequentially. What can I do to ensure all records
    > when manually searched through in the Form View appear in numerical
    > order?


    It is best to consider an Access table as a bucket of data records. It
    is not the best place to view or edit records. I suggest queries, forms and
    reports for that. In a query you can set up a sort order and then the
    records will appear in the order expected.

    I might also suggest that many people who use autonumbers and let users
    see them are disappointed when they find that they get out of order or start
    missing numbers. Autonumbers can only be counted on to provide unique
    numbers, the order they appear or the use of all numbers is something akin
    to optional with autonumber.

    --
    Joseph Meehan

    Dia duit
     

Share This Page