OpenOffice Tutorial: Set an existing query's sort order
- To edit an existing query's sort order, first make sure you're in the queries view by clicking on the "Queries" icon here.
- Next, look for the name of the query you want to edit and right-click over its name.
- Then, on the menu that opens, click on "Edit"
- Once the query design view opens, you should see the fields included in the query represented by columns.
- Currently, the "LastName" and "FirstName" fields in this query have not been set a sort order.
- First, we shall set the sort order for the "LastName" field. Move your mouse here in the row marked "Sort" under the LastName column and click on the area once. This should reveal a down-arrow, click on that as well.
- You should see the list of sort orders. Just choose between the "Ascending" or "Descending" options depending on the way you want to sort the results of this field.
- Then, just click once on the choice you want.
- Repeat the process for the other fields you want sorted.
- Once done, click here on the save button to save the changes you have made.
- Now, click on this "X" icon to close the design view.
- Afterwards, it will be a good idea to check if our sort order has taken effect. So, right-click again over the name of the query.
- On the menu that appears, click on "Open."
- Great! As you can see the "LastName" field is set in Ascending order, from "Bush" to "Stewart."
- Congratulations! You have learned how to edit the sort order of existing queries.
by Kaj Kandler
Set an existing query's sort order
This screencast demonstrates how to set an existing query's sort order. You learn:
- How to open a query for editing.
- How to set the sort order of the fields in the query.
- Hot to save the changes made to a query.
For advanced functionality with similar results see:
- Sort query results in ascending order
- Sort query results in descending order
- Sort query results with multiple columns/fields
OpenOffice.org™ is a registered trademark of Oracle.
LibreOffice™ is a trademark of The Document Foundation.
Windows® is a registered trademark of Microsoft Corporation in the United States and other countries.