Working with Queries

From LibreOffice Help
Jump to: navigation, search

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.

Creating a New Query With the Query Wizard

In LibreOffice you can create a new query using the Query Wizard:

  1. Open the database file where you want to create the new query.
  2. In the left pane of the database window, click the Queries icon.
  3. Click Use Wizard to Create Query.

Creating a New Query With the Design View

  1. Open the database file where you want to create the new query.
  2. In the left pane of the database window, click the Queries icon.
  3. Click Create Query in Design View.

You see the Query Design window.


Related Topics

Using Databases in LibreOffice Base

Database Overview