Welcome to SPN

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

Sign Up Now!

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
    >
    >
    >
     

Share This Page