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( ) ).
