Ne kadar basit o kadar iyi.
AylikBakiye adlı sorgu istediğiniz sonucu veriyor.
AylikBakiye_AyYil:
Kod:
SELECT TRANSACTIONS.account_id, Month(transaction_date) AS balance_month, Year(transaction_date) AS balance_year
FROM TRANSACTIONS
GROUP BY TRANSACTIONS.account_id, Month(transaction_date), Year(transaction_date);
Kod:
SELECT AylikBakiye_AyYil.account_id, AylikBakiye_AyYil.balance_year, AylikBakiye_AyYil.balance_month, DSum("[transaction_amount]","TRANSACTIONS","[account_id]=" & [account_id] & " And (Year([transaction_date])<" & [balance_year] & " Or (Year([transaction_date])=" & [balance_year] & " And Month([transaction_date])<=" & [balance_month] & "))") AS monthly_balance
FROM AylikBakiye_AyYil
ORDER BY AylikBakiye_AyYil.account_id, AylikBakiye_AyYil.balance_year, AylikBakiye_AyYil.balance_month;