Adding computed fields to a form

You can use computed fields to perform calculations in the form. Typical uses of computed fields include:

• Calculations based on column data that change for each retrieved row

  For example, if you are retrieving yearly salary, you could define a computed field that displays monthly salary (defined as Salary / 12).

• Summary statistics

  For example, you can use a computed field to calculate the average salary of all the retrieved rows.

• Concatenated fields

  For example, if you are retrieving first name and last name, you can define a computed field that concatenates the values so that they appear with only one space between them (defined as Fname + " " + Lname).

• System information

  For example, you can place the current date and time in a form by using computed fields (defined as Today( ) and Now( ) ).