How do you set the sort order so the results will display records with the highest number of credits first?

query.ResultsRibbon Group, you clicked the Runbutton.34Set the sort order so the results will display records with the highest number of credits first. Run the query and review the results.1/1In the HomeRibbon Tab in the Sort & FilterRibbon Group, you clicked the Selectionbutton, clicked the Selectionbutton, clicked the Selectionbutton, and clicked the Selectionbutton. You clicked the Creditsfield's sortrow, expanded the Creditsfield's sort options list, and selected the Descendingoption. In the DesignRibbon Tab in the ResultsRibbon Group, you clicked the Runbutton.35Add criteria to this query to return only the records where the value in the Creditsfield is greater than 120and less than 130. Run the query to view the results.1/1You clicked the Credits field's criteria row, changed the Credits field's criteria to >120 and <130, clicked the Credits field's criteriarow, changed the Credits field's criteria to ">120 and <130, clicked the Credits field's criteria row, changed the Credits field's criteria to ">120 And <130, clicked the Credits field's criteria row, and changed the Credits field's criteria to >120 And <130. Inthe DesignRibbon Tab in the ResultsRibbon Group, you clicked the Runbutton.36Add criteria to this query to return only the records where the value in the Credits fieldis >124and the value in the Classificationfield is SrRun the query to view the results.1/1You clicked the Credits field's criteria row, changed the Credits field's criteria to >124, clicked the Classification field's criteria row,and changed the Classification field's criteria to Sr. In the DesignRibbon Tab in the ResultsRibbon Group, you clicked the Runbutton.37Add criteria to this query to return only the records where the value in the DeptCodefield is ENGor CIS. Run the query to view the results.1/1You clicked the DeptCode field's criteria row, changed the DeptCode field's criteria to ENG, clicked the deptCode field's or row, and changed the deptCode field's or rowto CIS. In the DesignRibbon Tab in theResultsRibbon Group, you clicked the Runbutton.38Preview how the results of this query will look when printed when the page orientation is changed to landscape.1/1You opened the backstage view, clicked the Printnavigation button, and clicked the Print Previewbutton. In the Print PreviewRibbon Tab in the Page LayoutRibbon Group, you clicked the Landscapebutton.39 Change the Field Sizeproperty for the RAStudentID field to 4.1/1In the AccessTable, you clicked on RAStudentID. In the FieldsRibbon Tab in the PropertiesRibbon Group, you typed 4in the Field Sizeinput, pressed the Enter

Try the Access Course for Free!

Overview of Sorting a Query in Access

            You can sort a query in Access by any field within the QBE grid when viewing the query in design view. To sort a query in Access when in design view, click into the “Sort” row of the field in the QBE grid by which to sort the result set. Then use the drop-down that appears to select either “Ascending” or “Descending” order.

            If you sort by multiple fields in Access, the order of the sorting is applied by field, from left to right, when viewing the result set. When sorting this way, you include the sorting criteria in the query’s SQL code. This then sorts the query result set the same way each time you run the query. To remove this type of query sorting, select the “(not sorted)” choice from the “Sort” row’s drop-down for the field from which to remove sorting in the QBE grid.

            Alternatively, you can apply sorting to a query result set in Access without changing its SQL code. Doing this only changes the way that the query result set appears while you view it in datasheet view.

            To sort by fields when viewing the query result set in datasheet view in Access, click the drop-down arrows at the top of the columns by which to sort the data. Then select either “Sort A to Z” or “Sort Z to A” from the drop-down. Alternatively, select a column. Then click either the “Ascending” or “Descending” buttons in the “Sort & Filter” button group on the “Home” tab of the Ribbon. To remove all sorting from the query result set, click the “Remove Sort” button in the “Sort & Filter” button group on the “Home” tab of the Ribbon.

            Alternatively, to use the ORDER BY clause in the SQL View of an Access query to sort a query in Access, please see our other blog post on “How to Use the ORDER BY Clause in SQL. That blog post contains additional information and links about how to use the ORDER BY clause to sort query results when writing queries in SQL View in Access.

Instructions on How to Sort a Query in Access

1. To sort a query in Access in the query design view, click into the “Sort” row of the field in the QBE grid by which to sort the result set.
2. Then use the drop-down that appears to select either “Ascending” or “Descending” order.
3. If you sort by multiple fields in the query design view in Access, the order of the sorting is applied by field, from left to right, when viewing the result set.
4. When sorting this way, you include the sorting criteria in the query’s SQL code. This then sorts the query result set the same way each time you run the query.
5. To remove this type of query sorting, select the “(not sorted)” choice from the “Sort” row’s drop-down for the field from which to remove sorting in the QBE grid.
6. Alternatively, to sort a query result set in Access when viewing it in datasheet view, click the small drop-down arrows at the top of the columns by which to sort the data.
7. Then select either “Sort A to Z” or “Sort Z to A” from the drop-down that appears.
8. Alternatively, select a column and then click either the “Ascending” or “Descending” buttons in the “Sort & Filter” button group on the “Home” tab of the Ribbon.
9. To remove all sorting from the query result set, click the “Remove Sort” button in the “Sort & Filter” button group on the “Home” tab of the Ribbon.

Video Lesson on Sorting Queries in Access

            The following video lesson, titled “Sorting Query Results,” shows how to sort a query in Access in different ways. This video is from our complete Access tutorial, titled “Mastering Access Made Easy v.2019 and 365.”

Tagged under: access, access 2013, Access 2016, Access 2019, Access for Microsoft 365, Access for Office 365, access query custom sort, access query sort order, access sort query, column, columns, course, datasheet view, design query, design view, field, fields, help, how can you sort data in access, how to sort a query in access, how to sort alphabetically in access query, how to sort query in access, how-to, instructions, learn, lesson, Microsoft Access, order by access, overview, queries, query, query sort, result set, set the sort order in access, sort, Sort a Query in Access, sort by multiple columns in access, sort columns, sort query, sorting, sorting a query in access, sorting queries in access, teach, training, tutorial, video

How do you set the sort order so the results will display records with the highest premium first?

How do you limit the query results to records where the value in the credits field is greater than 120?

How would you sort records in a field so that the oldest birthday is listed first?

How do you use AutoFilter to filter the query results to show only records where the value in the Department field is accounting or finance?