Share via

How to sort within a sort

Anonymous
2012-11-16T14:49:44+00:00

Can anyone give me step by steps to sort a table by a field in ascending order , then within this sort show another field in ascending order please?  I have vague notes about using advance filter sort to do the first sort, then do a basic sort but I'm stuck as to how to do the next sort.   The table I am sorting is very basic and has 6 fields in total.

Microsoft 365 and Office | Access | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

HansV 462.6K Reputation points
2012-11-16T14:57:14+00:00

Open the table.

On the Home tab of the ribbon, in the Sort & Filter group, click Advanced > Advanced Filter/Sort...

Add the first field you want to sort on to the first column of the grid, and select Ascending in the Sort: row.

Add the second field you want on to the second column of the grid, and select Ascending in the Sort: row.

Click Toggle Filter on the ribbon to apply the sort.

Was this answer helpful?

3 people found this answer helpful.
0 comments

9 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2012-11-16T21:33:25+00:00

    Many thanks for all your replies. :)

    Was this answer helpful?

    0 comments
  2. Anonymous
    2012-11-16T19:53:08+00:00

    It is important for you to understand that the ONLY way records can be sorted is by using a query with the sort specified in its ORDER BY clause. 

    A further note --  For a report you must apply a sort there as table and query sorts will not be passed along.

    Was this answer helpful?

    0 comments
  3. Anonymous
    2012-11-16T16:11:02+00:00

    It is important for you to understand that the ONLY way records can be sorted is by using a query with the sort specified in its ORDER BY clause. 

    You can use the table properties as Hans described to tell Access how to construct the query it will use to display the table's datasheet, BUT the records in the table will not be sorted.  Only the order the records are displayed in sheet view is affected.   In other words, a table is just a bucket of records that can be stored in whatever order for whatever reason the database engine developers thought would be efficient in retrieval time, storage space, code complexity or ...

    Was this answer helpful?

    0 comments
  4. Anonymous
    2012-11-16T16:08:39+00:00

    Just remember that a sort applied at table level in its Sort Order property is NOT going to sort it anywhere else (query, form, report).  It is only good for that "view" of a table.  When looking at a table directly, you really are not looking at the table, but a system query of the table.

    Was this answer helpful?

    0 comments