Warning: This site requires the use of scripts, which your browser does not currently allow. See how to enable scripts.

When you use a math function in an expression, you use **operators** — plus signs and other familiar symbols. Access uses all the common operators, plus a few you may not know.

If you need an exponent - a number multiplied by itself - use the caret (

**^**). For example, the number eight, the caret, and the number 2 (**8^2**) is the same as 8 multiplied by 8. If you need a negative value, place a minus sign to the left of the number. For example,

**-2**. To multiply, use the asterisk. To divide, use the forward slash (

*** /**). If you work with numbers that don't divide evenly, use the integer division operator, the backslash (

**\**). For example, if you use the backslash to divide 26 by 10, the quotient — the result — is 2. If you need to show the remainder of an integer division operation, use the

**mod**, or modulus, operator. For example,**26 mod 10**gives a result of 6, the remainder of the integer division operation. To add numbers, use the plus sign. To subtract, use the minus sign (

**+ -**).Now remember, Access executes math operations in the order listed here. For example, it performs an exponent operation before anything else, it multiplies before it divides, and it adds before it subtracts. That is called **operator precedence**. You can override operator precedence by using parentheses in your formulas, and that's next.