Operators are symbols that denote some kind of operation. Operators can be of the following types:
- Mathematical operators: Mathematical operators are used for performing mathematical calculations. The operators are as follows:
- + (plus): Plus can be used for addition (numeric and date fields) and string concatenation. For example, 4+2 will return 6 while Abc + Def will return AbcDef. We can use addition for dates as well, for example, adding #23-04-2019#+4 will give #27-04-2019#.
- - (minus): Minus can be used for the subtraction of dates and numeric fields, in a similar way to the + operator.
- * (multiplication) and / (division): This is used to multiply or divide numeric fields.
- % (modulo): This returns the remainder of a ...