LibreOffice 24.8 Help
If you often want to access only a subset of your data that can be well defined by a filter condition, you can define a query. This is basically a name for the new view at the filtered data. You open the query and see the current data in the table layout that you defined.
In LibreOffice you can create a new query using the Query Wizard:
Open the database file where you want to create the new query.
In the left pane of the database window, click the Queries icon.
Click Use Wizard to Create Query.
Open the database file where you want to create the new query.
In the left pane of the database window, click the Queries icon.
Click Create Query in Design View.
You see the Query Design window.