How To Create A Calculated Field In Access 2016

Do you know how the Access calculated fields is useful? Don't know? Not to worry as this post will help you in easy learning of how this field is useful and how to use it.

Calculated field are special type of fields that calculates the values from other fields within a table as well as from built in access function. After then display the calculated result.

Steps To Create A Calculated Field In Access 2016


In the datasheet view open the table and scroll to the right most field.

Click to Add field heading after then select Calculated Field from the drop-down menu and then choose the data type that you want the result to come in.

Now launch the Expression Builder. To do this choose the More Fields > Calculated Field from the Field tab.


To perform the calculation that you want, use the Expression Builder.

Or just type the expression if you have knowledge on this.

Here in the shown example, we are dividing the population field by the area field. So, we type [Population] / [Area]. This is to calculate the number of people per kilometer.

So, after entering down the expression tap to the OK option.


Field header will be highlighted, so enter the appropriate name to it. Go ahead and enter a name for the field.


Now the calculated filed is complete. You have to expand the width of the field in order to show the values.


Rounding the Numbers

If you calculated field gives too many decimal places, then also you can easily adjust this.

For this, just simply select the field and ensures that the Fields tab is selected in the Ribbon, tap to one of the little rounding icons.

In order to decrease the decimal places, click the icon on the right and to increase click the left one.

Modify the Expression

You can run the Expression Builder in case you need to modify the expression. For this, select the calculated field that you want to update and then click Modify Expression option from the field tab in the Ribbon.