Useful Operators for Access Expressions

Use these resources to learn about the large variety of useful operators that can be used when building an expression in Microsoft Access. If you do not know about these operators, you are missing out!

Microsoft Table of Operators for Access: breaks down the expressions into the major categories

Useful Arithmetic Operators (“+”, “-“, “* “, “/ “, “\”, “Mod”, “^”) that you should know

Comparison Operators (“<” , “>” , “=” , “<>” ,”<=”, “>=”) that you need to know

Logical Operators (“AND”, “OR”, “XOR”, “NOT”, “EQV”, “IMP”) that you must know

Handy Concatenation Operators (“& “, “+”) that you must know