C
cliff
I am bit new to access, trying best learn. I have small problem in creating
report somelike this for my investment:-
cdate Particulars dr cr balance
1/01/2001 Trf from sb 41 25000 25000
1/01/2004 Interest 1000 26000
1/01/2006 Interest 500 26500
1/01/2006 withdrawal 6500/- 20000
1/07/2006 Interest 200 20200
1/7/2006 withdrawal 8000/- 12200
current Balance 12200/-
further I want tabular statement something like this :-
particulars 2001 2004 2005 2006
Investment A 25,000/-
Interest earned 1000/- 700/- 800/--
balance 25,000/- 26000/-12,200/-
Investmet B 30,000/-
interest earned 1500/- 1800/- 2500/-
total balance in all funds 42,200/-
mytbales are something like :-
deposit table
depositid (primary key)
date
accountno
receiptno
amount
rate
period
interest table
intrestid (primary key)
depositid (forgien key)
date
receiptno
amount
withdrawal table
withdrawid (primary key)
depositid (forgien key)
date
receipt
amount
please help to write query to display report and investmentwise statement as
stated above.
thnaks million
cliff
report somelike this for my investment:-
cdate Particulars dr cr balance
1/01/2001 Trf from sb 41 25000 25000
1/01/2004 Interest 1000 26000
1/01/2006 Interest 500 26500
1/01/2006 withdrawal 6500/- 20000
1/07/2006 Interest 200 20200
1/7/2006 withdrawal 8000/- 12200
current Balance 12200/-
further I want tabular statement something like this :-
particulars 2001 2004 2005 2006
Investment A 25,000/-
Interest earned 1000/- 700/- 800/--
balance 25,000/- 26000/-12,200/-
Investmet B 30,000/-
interest earned 1500/- 1800/- 2500/-
total balance in all funds 42,200/-
mytbales are something like :-
deposit table
depositid (primary key)
date
accountno
receiptno
amount
rate
period
interest table
intrestid (primary key)
depositid (forgien key)
date
receiptno
amount
withdrawal table
withdrawid (primary key)
depositid (forgien key)
date
receipt
amount
please help to write query to display report and investmentwise statement as
stated above.
thnaks million
cliff