Newbie Question

[nazia]

Hello-
Please forgive me- I know next to nothing about access.

I have a donations database where I track each Donor and donation and campaign for record keeping and analysis. I have created separate tables for each.

In the Campaign Table, I have the fields:
-Campaign ID
-Campaign Name
-Start date
-end date
-fundraising goal
-total raised to date
And in the Donations Table, I have the fields:
-Donation ID
-Donor
-Donations Total
-Campaign
-Payment method

I would like the "Total Raised to Date" Field in the "Campaign" table to calculate all of the donations from the "Donations" Table that fall into a particular campaign ID.

How should I go about doing this? THANK YOU.

 

[bob fitz]

Hi
I don't think your table structure and relationships are quite right.
Take a look at the db attached, which is a MS template db I found with google and then post back if you need more help.

 

[PaulO]

Hello-
Please forgive me- I know next to nothing about access.

I have a donations database where I track each Donor and donation and campaign for record keeping and analysis. I have created separate tables for each.

In the Campaign Table, I have the fields:
-Campaign ID
-Campaign Name
-Start date
-end date
-fundraising goal
-total raised to date
And in the Donations Table, I have the fields:
-Donation ID
-Donor
-Donations Total
-Campaign
-Payment method

I would like the "Total Raised to Date" Field in the "Campaign" table to calculate all of the donations from the "Donations" Table that fall into a particular campaign ID.

How should I go about doing this? THANK YOU.

There really shouldn't be any need to update the Total Raised to Date figure ... if you ever need this figure you can it from the Donations table by using a SUM query.

 

[nazia]

Bob- I summarized the structure of the database, it looks pretty similiar to the database template you attached.

Paul- I know I can create a query but I already have a table with all the campaigns and the fundraising goals, it would be easier for comparison to have the totals pledges appear on the table.

I actually built the database off of hte MS Charitable Contribution Web Database Template. I wanted to simplify the database but I couldnt figure out how to modify aweb databases, so I just built a similar, simplified database.That template had this exact feature in the campaigns table.