help to write query

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top