Please refer to this post:
http://www.scriptcase.net/forum/showthread.php?6555-Fail-MS-Access-and-sc_concat&highlight=sc_concat
Essentially, I see that when using MS Access, sc_concat will only work with two parameters. By example
sc_concat(f1, f2) as f3 will work
sc_concat(f1, " ", f2) as f3 or sc_concat(f1, f2, f3, f4) will fail as an unrecognised function in ODBC.
MS Access syntax, i.e. f1 & " " & f2 & " " & f3 AS NewField provides a work around. However, now the project is no longer portable between databases.
Thanks