[AccessD] SQL concatenation

The syntax looks sound. Is it possible that one of the columns contains a
null? If so, that would break your expression. You'd have to Nz() them
before the concatenation.

You might also try pasting your expression into a new query in the designer
and check the results, then switch to SQL view and see what Access wrote.

An alternative is to create a UDF called CSC that accepts three parameters.
You can then test that in isolation and when it works, just call it from the
original query.

Arthur