son kararınız eğer toplu borçlandırmayı T_1_MemberDues tablosuna eklemek ise aşağıdaki kod işinize yarayabilir
'hy ekle________________________________
ClngAidat = CLng(Me.txtAidatTutari / 12)
StrEkle = " INSERT INTO T_1_MemberDues ( " & _
" UyeNo, Tarih, AidatTutari, TaksitSayisi, Ocak, Subat, Mart, Nisan, Mayis, Haziran, Temmuz, Agustos, Eylul, Ekim, Kasim, Aralik ) " & _
" SELECT " & _
" Gcc.UyeNo, Gcc.Tarih, Gcc.AidatTutari, Gcc.TaksitSayisi, Gcc.Ocak, Gcc.Subat, Gcc.Mart, Gcc.Nisan, Gcc.Mayis, Gcc.Haziran, Gcc.Temmuz, Gcc.Agustos, Gcc.Eylul, Gcc.Ekim, Gcc.Kasim, Gcc.Aralik " & _
" FROM (SELECT T_1_MemberDefinition.UyeNo, " & CLng(Me.txtTarih) & " AS Tarih, " & _
" CCur(" & Me.txtAidatTutari & ") AS AidatTutari, 12 AS TaksitSayisi, " & _
ClngAidat & " AS Ocak, " & ClngAidat & " AS Subat, " & ClngAidat & " AS Mart, " & ClngAidat & " AS Nisan, " & _
ClngAidat & " AS Mayis, " & ClngAidat & " AS Haziran, " & ClngAidat & " AS Temmuz, " & _
ClngAidat & " AS Agustos, " & ClngAidat & " AS Eylul, " & ClngAidat & " AS Ekim, " & ClngAidat & " AS Kasim, " & _
ClngAidat & " AS Aralik " & _
" FROM T_1_MemberDefinition " & _
" ) as Gcc"
CurrentDb.Execute StrEkle
'hy ekle________________________________