คำสั่ง concat และ substr ใน ms access database ใช้งานไม่ได้เลยครับ

SELECT dbo_ARFINC.SDATE, dbo_REGTAB.MODEL, dbo_REGTAB.BAAB, dbo_ARFINC.LOCAT, dbo_OFFICER.NAME, CONCAT(dbo_REGTAB.SNAM,dbo_REGTAB.NAME1,dbo_REGTAB.NAME2) as name3,(substr(dbo_ARFINC.ACTGARNO,7,2)/12),substr(dbo_ARFINC.ACTGARNO,1,4), dbo_ARFINC.TOTPRC, dbo_ARFINC.TOTDWN,dbo_ARFINC.TOTPRC -dbo_ARFINC.TOTDWN as sumprice, dbo_ARFINC.FINCOM, dbo_ARFINC.COMOTH, dbo_REGTAB.GARSPAY, dbo_ARFINC.INSURGARNO
FROM (dbo_ARFINC INNER JOIN dbo_REGTAB ON (dbo_ARFINC.CUSCOD = dbo_REGTAB.CUSCOD) AND (dbo_ARFINC.CONTNO = dbo_REGTAB.CONTNO)) INNER JOIN dbo_OFFICER ON dbo_ARFINC.SALCOD = dbo_OFFICER.CODE;