Welcome to SPN

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

Sign Up Now!
  1.   Become a Supporter    ::   Make a Contribution   
    Target (Recurring Monthly): $200 :: Achieved: $98

Permanent sort in table

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

  1. Mary Ann

    Mary Ann
    Expand Collapse
    Guest

    I have three fields which I want to use to sort the data in a table – a
    primary, secondary and tertiary sort.

    I have tried using the sort in datasheet view with the fields positioned so
    that the primary field is on the left of the secondary and that is to the
    left of the tertiary sort field. Initially this works ok but the sort
    doesn’t hold.

    Is there a way to set up a permanent sort on three fields in a table which
    will not be overwritten. I thought maybe the index field in design view
    might do this but there doesn’t seem a way to specify which is the primary,
    secondary and tertiary.

    I am using 2003
     
  2. Loading...

    Similar Threads Forum Date
    Cure Diabetes Permanently From Your Life Without Medicine Health & Nutrition Mar 10, 2015
    India China Backs Pak for Non-permanent UNSC seat, India Upset Breaking News Oct 19, 2011
    India IAF to give permanent commission to women officers Breaking News Aug 3, 2010
    Sikh News Blind Sikh social worker denied permanent visa Breaking News May 1, 2010
    The Permanent & True Place Interfaith Dialogues Feb 22, 2006

  3. Joseph Meehan

    Joseph Meehan
    Expand Collapse
    Guest

    Mary Ann wrote:
    > I have three fields which I want to use to sort the data in a table -
    > a primary, secondary and tertiary sort.
    >
    > I have tried using the sort in datasheet view with the fields
    > positioned so that the primary field is on the left of the secondary
    > and that is to the left of the tertiary sort field. Initially this
    > works ok but the sort doesn't hold.
    >
    > Is there a way to set up a permanent sort on three fields in a table
    > which will not be overwritten. I thought maybe the index field in
    > design view might do this but there doesn't seem a way to specify
    > which is the primary, secondary and tertiary.
    >
    > I am using 2003


    Use a query and you can do exactly what you want. Tables are not sorted
    and you should not expect them to maintain any specific order. You can use
    the query as a data source for reports, forms and other queries.

    --
    Joseph Meehan

    Dia duit
     
  4. John Vinson

    John Vinson
    Expand Collapse
    Guest

    On Mon, 10 Jul 2006 04:12:01 -0700, Mary Ann
    <MaryAnn@discussions.microsoft.com> wrote:

    >Is there a way to set up a permanent sort on three fields in a table


    No.

    A table HAS NO ORDER. It's an unsorted "heap" of data.

    If you want to see records in a particular order, the correct method
    is to index the three fields so that sorting will be fast and
    efficient, and use a Query with an Order By clause on the three
    fields. This Query can be used in any context where you would
    otherwise use the Table.

    Note that table datasheets are not designed or intended for user
    interaction - you should not generally be exposing them to user view
    at all, so the order of records in the table is (or should be!)
    irrelevant anyway.

    John W. Vinson[MVP]
     
  5. Mary Ann

    Mary Ann
    Expand Collapse
    Guest

    Thank you - very clear!

    "John Vinson" wrote:

    > On Mon, 10 Jul 2006 04:12:01 -0700, Mary Ann
    > <MaryAnn@discussions.microsoft.com> wrote:
    >
    > >Is there a way to set up a permanent sort on three fields in a table

    >
    > No.
    >
    > A table HAS NO ORDER. It's an unsorted "heap" of data.
    >
    > If you want to see records in a particular order, the correct method
    > is to index the three fields so that sorting will be fast and
    > efficient, and use a Query with an Order By clause on the three
    > fields. This Query can be used in any context where you would
    > otherwise use the Table.
    >
    > Note that table datasheets are not designed or intended for user
    > interaction - you should not generally be exposing them to user view
    > at all, so the order of records in the table is (or should be!)
    > irrelevant anyway.
    >
    > John W. Vinson[MVP]
    >
     
  6. Mary Ann

    Mary Ann
    Expand Collapse
    Guest

    Thank you Joseph. I shall do that and incorporate indexes as per John
    Vinson's message.

    "Joseph Meehan" wrote:

    > Mary Ann wrote:
    > > I have three fields which I want to use to sort the data in a table -
    > > a primary, secondary and tertiary sort.
    > >
    > > I have tried using the sort in datasheet view with the fields
    > > positioned so that the primary field is on the left of the secondary
    > > and that is to the left of the tertiary sort field. Initially this
    > > works ok but the sort doesn't hold.
    > >
    > > Is there a way to set up a permanent sort on three fields in a table
    > > which will not be overwritten. I thought maybe the index field in
    > > design view might do this but there doesn't seem a way to specify
    > > which is the primary, secondary and tertiary.
    > >
    > > I am using 2003

    >
    > Use a query and you can do exactly what you want. Tables are not sorted
    > and you should not expect them to maintain any specific order. You can use
    > the query as a data source for reports, forms and other queries.
    >
    > --
    > Joseph Meehan
    >
    > Dia duit
    >
    >
    >
     
Since you're here... we have a small favor to ask...

More people are visiting & reading SPN than ever but far fewer are paying to sustain it. Advertising revenues across the online media have fallen fast. So you can see why we need to ask for your help. Donating to SPN's is vote for free speech, for diversity of opinions, for the right of the people to stand up to religious bigotry. Without any affiliation to any organization, this constant struggle takes a lot of hard work to sustain as we entirely depend on the contributions of our esteemed writers/readers. We do it because we believe our perspective matters – because it might well be your perspective, too... Fund our efforts and together we can keep the world informed about the real Sikh Sikhi Sikhism. If everyone who writes or reads our content, who likes it, helps us to pay for it, our future would be much more secure. Every Contribution Matters, Contribute Generously!

    Become a Supporter      ::     Make a Contribution     



Share This Page