Dear Experts,
I have a Table named as “Transection Table” in MS Access 2016 as follows:
Transection Table TransectionID TransectionDate TransectionType Amount ClientID 1 09-06-20 Bill 4000 2 2 12-06-20 Bill 1000 1 3 16-06-20 Bill 45670 4 4 16-06-20 Bill 45670 5 5 24-06-20 Payment 45670 5 6 15-07-20 Bill 3000 3 7 17-07-20 Payment 500 1 8 18-07-20 Bill 1000 1 9 20-07-20 Bill 5000 1 10 20-07-20 Payment 2500 3 11 22-07-20 Payment 1234 4 12 25-08-20 Bill 5000 3
Now I want to generate Ledger statement for each client from my Transection Table through MS Access Query which would generate Ledger statement report like Below:
Ledger Statement Report Opening Balance ClientID TransectionDate TransectionType Amount Closing Balance 0 1 12-06-20 Bill 1000 1000 1000 1 17-07-20 Payment 500 500 500 1 18-07-20 Bill 1000 1500 1500 1 20-07-20 Bill 5000 6500 0 2 09-06-20 Bill 4000 4000 0 3 15-07-20 Bill 3000 3000 3000 3 20-07-20 Payment 2500 500 500 3 25-08-20 Bill 5000 5500 0 4 16-06-20 Bill 45670 45670 45670 4 22-07-20 Payment 1234 44436 0 5 16-06-20 Bill 77566 77566 77566 5 24-06-20 Payment 77566 0
Please anyone do this for me by suggesting appropriate SQL query and report. Your assistance will be much appreciated !! Thanks In Advance !!
Ashik
Dhaka , Bnagladesh