Calculating the sum of the data in a column

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.

1. Click on the table. Right-click and select Table Column Summation Wizard.
2. 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.
3. Click OK.
   A field will appear under the furthest right field of the table.

   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.