Function Syntax Rules
The following syntax rules apply to the use of functions in calculated fields:
-
A function may be entered in uppercase or lowercase.
-
Month(SaleDate)
-
MONTH(SaleDate)
-
month(SaleDate)
-
Function arguments must be enclosed in parentheses.
-
Multiple arguments must be separated by commas or semicolons (depending upon your Windows Language settings), and they must appear in the order specified by the function definition.
-
A function may be embedded as an argument within another function.
For example, all of the following are valid:
For example: Month(SaleDate)
Where SaleDate is a column in the table, and is the argument to the function Month( )
For example: Instr("North",Region)
Where "North" and Region are both required arguments. (In this example, we are searching for the text "North" among all values of the Region column.
For example: Instr("North", Intrim(Region))
Where "North" and Region are both required arguments. (In this example, we are searching for the text "North" among all values of the Region column, after all Region values are trimmed of duplicate spaces.