Update Query using concatenate

[Michael Abrams]

Good Morning,

I have been doing this for 20 years and should be able to get this.

But I can't.

I am writing an update query to update field "New Group" ​in table 1

BS-WOOO1864-M0024515
Where WOOO1864 is field GROUPID in table 1
and M0024515 is field PLANID in table 1

I have tried variations of
“BS-“&[GroupID]&”-”&[ PlanID]

Please assist and thank you so much for all of the help over the years.

Michael Abrams

[HansV]

Access, VBA and SQL require straight quotes ", not curly quotes “ ”.
And there should always be a space before and after the concatenation operator &.

"BS-" & [GroupID] & "-" & [ PlanID]

[Michael Abrams]

Thanks HansV - works great!