How to Calculate Fields in OpenOffice Base

Updated April 17, 2017

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.

bibliography-icon icon for annotation tool Cite this Article

About the Author

Meg North has written professionally since 2008 as an online copywriter for the Sturbridge Yankee Workshop. She also published a short story in "The Maine Scholar." North has a Bachelor of Arts in media writing from the University of Southern Maine.