Piece of cake!!!

Hello...

I've created an excel 2000 file (Included) to solve the requirement of my colony's funds. Now I want to change all the system to Access 2000. I've created four tables:

1. Personal (includes SNo as pk, Name, Income)
2. Total Budget (Aam, Jalsa, SNo as fk)
3. Recovery (Aam, Jalsa, SNo as fk)
4. Balances (Aam, Jalsa, SNo as fk)

You see in excel file there are some more columns represents the Months in which the fund that raised from people is listed. I dont know how to represent these months and received amount in months in Access Table.

Thanks...
Nauman Ahmed

Hi

I think the best way to do this will be to create one more table
(fund) with fields

personalkey,aam,jalsa,month,year ( is is for future compatiblility)

what i mean here is the personalkey is a foriegn key to the
personal table and will be used to link to each person

aam and jalsa shall have the amount with month and year

assume you have table personal
with field personalkey,name

so lets say you want to know the find raised by jayesh in month jan for year 2002

select aam,jalsa from personal,fund where fund.personalkey = personal.personalkey and month = "jan" and year ="2002"

you can skip the year part if you want to

hope this helps

cheers

jayesh jain

Thanks a lot...

I've never thought of extra Month and year field

Thanks...
Nauman Ahmed