How to Calculate Fields in OpenOffice Base

Written by meg north | 13/05/2017
How to Calculate Fields in OpenOffice Base
Type the two fieldnames in the column separated by the calculating data symbol. (Jupiterimages/Comstock/Getty Images)

Create a calculated field in's open-source database program, Base. Base can create tables and queries given an input set data. Data symbols such as an asterisk for multiplication or a slash for division are used for calculation. Once the calculation is typed into the query cell, the results appear in the column below. You choose the data to calculate and it can be custom-tailored to your data results. You can also run the data as a query.

Click "Start" and "All Programs." Click "Open" and click "Base" to open.

Click "Create a new database" or "Open an existing database" if you've already created one. Click "Next." Click the options for proceeding after saving the database and click "Finish."

Click "Create or add a table" and click the "Queries" icon on the left-hand side. Click "Create Query in Design View" to open the query window.

Click on the radio button next to the table. Click the fields to add and click "Add."

Add fields to the spreadsheet query at the bottom of the screen by double-clicking on them.

Calculate the fields by first clicking the first cell of the first blank column. Type the name of the fieldname, an asterisk and the name of the second fieldname: "firstfieldname*secondfieldname."

Click the cell below the calculated field. Type the name of the calculated field.

Click the "Run Query" button to run the query.

By using the site, you consent to the use of cookies. For more information, please see our Cookie policy.