No problem.

When I first saw the code myself I thought the OP was trying to use the VBA Format function.

Just looking at the error message I think the problem lies/starts somewhere here.
"SELECT Format([org_param_value].[param_effective_date],0) + [org_parameter].[param_id] AS [LookupValue]
I'd test it but I don't really have time to set up something to test it with.