Making simple field calculations
Performing field calculations is an easy way to batch update many records at once in your table. The Field Calculator works on string, number, and date fields and automatically calculates selected records if the layer or table has a selection set present.
- Start an edit session. You can make calculations without being in an editing session; however, in that case, there is no way to undo the results.
- Right-click the layer or table you want to edit and open its table.
-
Right-click the field heading for which you want to make a calculation and click Field Calculator.
Note:If you are working with the attribute table of a geodatabase feature class that participates in a geodatabase topology, geometric network, or a relationship class, the Field Calculator command is unavailable when you are not in an edit session.
Tip:You can press CTRL+SHIFT+F as a shortcut to opening the Field Calculator.
-
Use the Fields list and Functions to build a calculation expression. You can also edit the expression in the text area or type a value for the field.
Tip:
Use double quotes when calculating strings.
Note:Fields that have been turned off for the layer or table you are working with are not listed in the Field Calculator. Field visibility is set on the Fields tab of the Layer Properties or Table Properties dialog box or from the Table window. - Click OK.
Tip:When you use the Field Calculator on a text field, a warning message appears if truncation occurs because the field length is too small to hold the calculated values. Truncated values are flagged with an asterisk so you can easily find and fix them if necessary.
Note:To avoid seeing the warning message when you attempt to calculate values outside an edit session, you can check the Don't warn me again box on the message. You can turn on the warning message again from the Tables tab of the Customize > ArcMap Options dialog box.
Caution:You can't undo a field calculation when performed outside an edit session.