Hi,
I have the following but it keeps throwing up an error, all works fine in other queries where i'm not trying to concatenate 2 fields.
What is wrong?

strSQL = "SELECT Format([org_param_value].[param_effective_date],0) & [org_parameter].[param_id] AS [LookupValue], org_param_value.param_effective_date, org_parameter.param_id, org_parameter.param_daily_name, org_param_value.param_value, org_param_value.param_rag, daily_report_items.cmi_parent, daily_report_name.cmn_id " & _

Thanks in advance.

Kerry