Kod:
SELECT
IIf(Left([Giren Kullanici],1)='U',Right([Giren Kullanici],Len([Giren Kullanici])-3),Right([Giren Kullanici],Len([Giren Kullanici])-2)) AS GIRENKULLANICI,
IIf(Left([Degis Kullanici],1)='U',Right([Degis Kullanici],Len([Degis Kullanici])-3),Right([Degis Kullanici],Len([Degis Kullanici])-2)) AS DEGISTIRENKULLANICI,
MH_BORC_DUZELTME.Yilay,
Sum(MH_BORC_DUZELTME.MH_Borc_Girilen) AS MH_Borc_Girilen,
Sum(MH_BORC_DUZELTME.MH_Borc_Degistirilen) AS MH_Borc_Degistirilen INTO T_MH_BORC_DUZELTME
FROM MH_BORC_DUZELTME
GROUP BY MH_BORC_DUZELTME.Yilay, MH_BORC_DUZELTME.[Giren Kullanici], MH_BORC_DUZELTME.[Degis Kullanici]