An expression cannot be used as a parameter value.
From Microsoft Office Access 2003
An expression cannot be used as a parameter value.
An expression appears as a parameter value. Parameter values must be scalar quantities or simple text. Supply a text value or number for the quantity, as appropriate.