Plan-B for & LibreOffice, learning office productivity software with videos
Tech Support for & LibreOffice

OpenOffice Tutorial: Set an existing query's sort order

How-To: OpenOffice Tutorial: Set an existing query's sort order
  1. To edit an existing query's sort order, first make sure you're in the queries view by clicking on the "Queries" icon here.
  2. Next, look for the name of the query you want to edit and right-click over its name.
  3. Then, on the menu that opens, click on "Edit"
  4. Once the query design view opens, you should see the fields included in the query represented by columns.
  5. Currently, the "LastName" and "FirstName" fields in this query have not been set a sort order.
  6. 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.
  7. 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.
  8. Then, just click once on the choice you want.
  9. Repeat the process for the other fields you want sorted.
  10. Once done, click here on the save button to save the changes you have made.
  11. Now, click on this "X" icon to close the design view.
  12. 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.
  13. On the menu that appears, click on "Open."
  14. Great! As you can see the "LastName" field is set in Ascending order, from "Bush" to "Stewart."
  15. Congratulations! You have learned how to edit the sort order of existing queries.


Show OpenOffice Tutorial: Set an existing query's sort order

Set an existing query's sort order

This screencast demonstrates how to set an existing sort order. You learn:

  • How to open a query for editing.
  • How to set the sort order of the in the query.
  • Hot to save the changes made to a query.

Advanced topics

For advanced functionality with similar results see:™ 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.

Further questions?

* required fields