INSERT INTO CID_DEATH1 ( CID, DEATHDATE )
SELECT CID_DEATH.CID, DateSerial(Left([CID_DEATH].[DEATHDATE],4),Mid([CID_DEATH].[DEATHDATE],5,2),Right([CID_DEATH].[DEATHDATE],2)) AS Expr1
FROM person INNER JOIN CID_DEATH ON person.idcard = CID_DEATH.CID;
