After creating a table, you can add the values of all the items in one column using the Table Column Summation Wizard. The result is copied to a target item located in the table.
To sum the data entered in a column:
- Click on the table. Right-click and select Table Column Summation Wizard.
- From the Choose a Field list, select a field by either:
- Clicking on a field listed in the popup. The list items in the table and those on your form are displayed.
- Clicking to select a field. The Table Column Operation window shrinks so you can see the entire form and choose the field. Once you have selected the field, the Table Column Operation window expands.
A field will appear under the furthest right field of the table.
Parent topic: Creating tables using a wizard
Note: If you have defined your table to display a number of rows, the user must fill in data into each row before the summation of the column is displayed in the chosen field. Empty fields will either be seen as a zero or will provide an error, depending on how the fields are set.