To select all minerals with hasY set to Yes, click into the hasY cell of the Criterion row and enter TRUE.Notice that the first four Table cells indicate the source table, CesbronList, and the first four Visible cells include the Yes check mark. From the appearing CesbronList field list, drag the names of those fields you want to include in your query into the cells of the Field row of the table in the lower section of the Query Design window: drag ID, MinName, MinFormula and hasY into the first, second, third and fourth Field cell, respectively.Add CesbronList and Close the Add Table or Query dialog.to open the Query Design window with the pop-up Add Table or Query dialog. In the Tasks pane, select Create Query in Design View.If not yet done, create the relationship as shown in the previous lesson. In the following example we use the ooBase Design View tool to create a query that selects all minerals from CesbronList that contain yttrium (Y): You will consider using a query to review, filter and modify data as well as performing tasks such as calculations and report generation. Queries support you in maintaining and updating the database. Defining and creating relationships between OpenOffice ™ Base tablesĪ query can answer specific questions about data stored in an ooBase application.Modifying the column layout of an existing OpenOffice ™ Base table.Structuring rare-earth mineral data in an OpenOffice ™ Base table.Exploring OpenOffice ™ Base: an example involving rare-earth mineral data.This post continues my preceding OpenOffice™ Base ( ooBase) lessons: A contribution by Axel Drefahl,, September 22, 2016.

Group items in query openoffice base