SQL in VBA - Concatenating 2 fields

Originally Posted by gbeats101

Shouldnt the formatting part be enclosed in quotation marks

Format([org_param_value].[param_effective_date],'0') (try double quotes if this doesnt work, just be sure you double them up when creating the string)

I've tried '0' and double quotes too (doubling them up) and i'm getting the same error