Welcome to SPN

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

Sign Up Now!

Why does the sort order change...

Discussion in 'Information Technology' started by Sheila D, Jul 28, 2006.

Tags:
  1. Sheila D

    Sheila D
    Expand Collapse
    Guest

    Hi all

    This is not a particular problem, I'm just curious to know what determines
    the secondary sort when I have a query sorted just on a single date field if
    there are multiple records for the same date. Record order seems to change
    from day to day and I can't figure out why.....thanks for any answers
    Sheila
     
  2. Loading...

    Similar Threads Forum Date
    Buddhism Why Does Buddha Have A Jooda? Interfaith Dialogues Nov 29, 2014
    General Why does Caste still Persist with Sikhs? Hard Talk Jul 31, 2012
    General Why Does SPN Publish Third-Party Advertisement? Hard Talk Jul 15, 2011
    Why Interfaith Dialogue Doesn't Work - What We Can Do About It Interfaith Dialogues May 30, 2011
    Confucianism Who was Confucious and Why Does it Matter? Interfaith Dialogues May 23, 2011

  3. Douglas J Steele

    Douglas J Steele
    Expand Collapse
    Guest

    The order of records is essentially random unless you've got an appropriate
    sort defined.

    Tables are "buckets" of data: you should never make any assumptions about
    the physical order of records in them, since that order can be changed by
    doing updates to the table, and by compacting.

    --
    Doug Steele, Microsoft Access MVP
    http://I.Am/DougSteele
    (no e-mails, please!)


    "Sheila D" <SheilaD@discussions.microsoft.com> wrote in message
    news:5936CB00-04EF-4F83-A21F-037D8E02D8E3@microsoft.com...
    > Hi all
    >
    > This is not a particular problem, I'm just curious to know what determines
    > the secondary sort when I have a query sorted just on a single date field

    if
    > there are multiple records for the same date. Record order seems to change
    > from day to day and I can't figure out why.....thanks for any answers
    > Sheila
     

Share This Page