Yeni sorgu oluşturup Sql kaynağına aşağıdaki kodu ekle,
SELECT T_MUSTERICARIALT.MUSID, T_MUSTERICARIALT.ACL_UYGULAMAISTEMI, T_MUSTERICARIALT.SONUC, Format(DSum("[UYGULAMATUTARI]","T_MUSTERICARIALT","[MUSID]=" & [T_MUSTERICARIALT].[MUSID])+DSum("[UYGULAMATUTARI]*[KDV]/100","T_MUSTERICARIALT","[MUSID]=" & [T_MUSTERICARIALT].[MUSID]),"Currency") AS HESAPTO, Format(Nz(DSum("[odeme_tutari]","tbl_odeme_bilgileri","[MUSID]=" & [T_MUSTERICARIALT].[MUSID]),"0"),"Currency") AS ODEMTOP, Format(DSum("[UYGULAMATUTARI]","T_MUSTERICARIALT","[MUSID]=" & [T_MUSTERICARIALT].[MUSID])+DSum("[UYGULAMATUTARI]*[KDV]/100","T_MUSTERICARIALT","[MUSID]=" & [T_MUSTERICARIALT].[MUSID])-Nz(DSum("[odeme_tutari]","tbl_odeme_bilgileri","[MUSID]=" & [T_MUSTERICARIALT].[MUSID]),"0"),"Currency") AS KALAN
FROM T_MUSTERICARIALT INNER JOIN T_MUSTERIKAYIT ON T_MUSTERICARIALT.MUSID = T_MUSTERIKAYIT.MUSID
GROUP BY T_MUSTERICARIALT.MUSID, T_MUSTERICARIALT.ACL_UYGULAMAISTEMI, T_MUSTERICARIALT.SONUC, Format(DSum("[UYGULAMATUTARI]","T_MUSTERICARIALT","[MUSID]=" & [T_MUSTERICARIALT].[MUSID])+DSum("[UYGULAMATUTARI]*[KDV]/100","T_MUSTERICARIALT","[MUSID]=" & [T_MUSTERICARIALT].[MUSID]),"Currency"), Format(Nz(DSum("[odeme_tutari]","tbl_odeme_bilgileri","[MUSID]=" & [T_MUSTERICARIALT].[MUSID]),"0"),"Currency"), Format(DSum("[UYGULAMATUTARI]","T_MUSTERICARIALT","[MUSID]=" & [T_MUSTERICARIALT].[MUSID])+DSum("[UYGULAMATUTARI]*[KDV]/100","T_MUSTERICARIALT","[MUSID]=" & [T_MUSTERICARIALT].[MUSID])-Nz(DSum("[odeme_tutari]","tbl_odeme_bilgileri","[MUSID]=" & [T_MUSTERICARIALT].[MUSID]),"0"),"Currency");
