Sorting Query And Apply Multiple Sort In MS Access
The purpose of using Access 2016 is to ease the work on sorting the data that consist of information linked to other data. For example you have name Anne Gilbert with order 5 Cheesecakes. Whit this information if you move Anne Gilbert from one object to another object or Query, Anne Gilbert would still be the one ordering 5 Cheesecakes. You will now misguide it with Bill John who ordered 4 apple pies. So far it is easy until the extra attention should be put when you work with the multi sorting query.
Filtering the queries from different table is already handful for the beginner, but with the good preparation and pin point to help you manage the main purpose, you will handle it well. While in the same time filtering is not only from different tables and by double or triple Criteria, it can also be from multiple sorts.
• First of all you need to click the Design View from the Datasheet View. If you wish to follow the tutorial, Access 2016 and the sample database Access 2016 should have been installed in your computer.
• After that go and find the Sort row above the Criteria. Unlike the Criteria where you need to create the code according how you want certain data to be sorted, in Sort you have options either to filter it Ascending or Descending.
• Remember that the sorting filter works from the left to the right so be careful about the position of the fields. For example you want the data to be sorter Ascending from the city first and then Ascending by the last name of the customer. If you have 4 customers from Raleigh means 4 of them will be sorted in the same city based field and sorting 1 to 4 by their last name. Isn’t it easier to see the result later?
• If you found that the field you wanted to be sorted first is located on the right side of the second field, you can rearrange them by clicking the head of the field and then drag it to the left side position from the second field. You can also rearrange the second field location too if this is easier for you.
• After that don’t forget to click Run command on the Ribbon to apply the filter you already made. The result will be shown in the Datasheet View in table looks.
Originally posted 2017-02-26 17:30:15.
Source Tags: access form order by, access form sort order, access query custom sort, access query sort multiple fields, access report sort order, if you want the records in a table to be sorted alphabetically by last name and then, in a query to sort z to a by department (outermost) then a to z by last name (innermost), specify that the query will display records in ascending order access.