MS Access

Useful Functions

Nz( variant, [ value_if_null ] )
Return defined value if variant is null. value_if_null is optional. If value_if_null is not defined, then it will return zero-length string. Example of usage in MS Access Query Design View: Field: Expr1: Nz(AnyColumValue, "Value is null")
Ask for user input in query
You can use square bracket to ask for user input each time that the query is ran.
SELECT TableA.col
WHERE TableA.col=[Enter a VALUE];
IIF( condition, value_if_true, value_if_false )
If condition is true, then return value_if_true. Otherwise, return value_if_false. Example: IIF([Amount]>100, "Large", "Small")
Zeros padding.