Welcome to SPN

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

Sign Up Now!

Sort a Table

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

Tags:
  1. James

    James
    Expand Collapse
    Guest

    I don't know if this is possible or not, but I was wandering if anyone knew
    of how to sort in a table. I cannot seem to figure it out.

    Thanks
     
  2. Loading...

    Similar Threads Forum Date
    I am sort of new to Sikhism New to Sikhism May 3, 2013
    Consortium agrees to pay 11.3 billion dollars for SunGard Data Systems (AFP) Interfaith Dialogues Mar 28, 2005
    As A Child, Public Marches Of Sikhism Made Me Uncomfortable. They Still Do . Why ? Whats The Logic Hard Talk Oct 16, 2016
    Arts/Society Backyard Vegetable Garden Language, Arts & Culture Dec 27, 2013
    Heritage Now a Vegetable Market, Ranjit Singh's Royal Haveli a Picture of Neglect History of Sikhism Nov 11, 2013

  3. Allen Browne

    Allen Browne
    Expand Collapse
    Guest

    Use a query. In query design view, you can use the Sorting row to specify
    the field(s) to sort by.

    Think of tables as just unsorted buckets to hold your data.

    In practice, Access displays the data in primary key order. It also offers
    an A-Z button on the toolbar for sorting the table data, and asks if you
    want to save this change when you close the table. These are really just
    pretty toys though; real men use queries. :)

    --
    Allen Browne - Microsoft MVP. Perth, Western Australia.
    Tips for Access users - http://allenbrowne.com/tips.html
    Reply to group, rather than allenbrowne at mvps dot org.

    "James" <James@discussions.microsoft.com> wrote in message
    news:6FB9A63B-4EF4-4EE4-BCC5-885FBF474E09@microsoft.com...
    >I don't know if this is possible or not, but I was wandering if anyone knew
    > of how to sort in a table. I cannot seem to figure it out.
    >
    > Thanks
     
  4. SusanV

    SusanV
    Expand Collapse
    Guest

    Table sorting is unreliable at best - right-click the header > sort
    ascending (or descending). However, next time you open it it may or may not
    be sorted. Create a query from the table with the sort order defined
    instead, or better yet, a form.
    --
    hth,
    SusanV

    "James" <James@discussions.microsoft.com> wrote in message
    news:6FB9A63B-4EF4-4EE4-BCC5-885FBF474E09@microsoft.com...
    >I don't know if this is possible or not, but I was wandering if anyone knew
    > of how to sort in a table. I cannot seem to figure it out.
    >
    > Thanks
     
  5. MH

    MH
    Expand Collapse
    Guest

    Hello Allen,

    I was just wondering what your definition of a "real man" was? <g>

    MH


    "Allen Browne" <AllenBrowne@SeeSig.Invalid> wrote in message
    news:%23$Z%23XksmGHA.1912@TK2MSFTNGP02.phx.gbl...
    > Use a query. In query design view, you can use the Sorting row to specify
    > the field(s) to sort by.
    >
    > Think of tables as just unsorted buckets to hold your data.
    >
    > In practice, Access displays the data in primary key order. It also offers
    > an A-Z button on the toolbar for sorting the table data, and asks if you
    > want to save this change when you close the table. These are really just
    > pretty toys though; real men use queries. :)
    >
    > --
    > Allen Browne - Microsoft MVP. Perth, Western Australia.
    > Tips for Access users - http://allenbrowne.com/tips.html
    > Reply to group, rather than allenbrowne at mvps dot org.
    >
    > "James" <James@discussions.microsoft.com> wrote in message
    > news:6FB9A63B-4EF4-4EE4-BCC5-885FBF474E09@microsoft.com...
    >>I don't know if this is possible or not, but I was wandering if anyone
    >>knew
    >> of how to sort in a table. I cannot seem to figure it out.
    >>
    >> Thanks

    >
    >
     

Share This Page