如何使用sql（access）将数字列（fieldname）拆分为2列

I have a table with a numeric column (Fieldname) which has numerical values (year and month ,no day) without seperator.I have a table with a numeric column (Fieldname