Totaling sum of field in relational database

[FM4me]

I helping a non-profit organisation create a small database to keep track of donations made by the sponsors, I created two files named donations.fp5 and donators.fp5, where i link both using the relations membership id to donators ID, but i am getting into difficult when i want to create a report to generate all the donations made by each and all members in the year.

I am still pretty newbie in filemaker pro 6 but really want to help and complete this small project as the organisation cannot afford an out of the box software to do all these, it is also a learning opportunity for me as i am helping them out, so please anyone who can help, could help with me send tips on how i can get this this report to give a reasonable result.

Rigght now, when i run the report, instead of the totals for each member, it gives the totals for all the members added together.

thank you :test:

[-Queue-]

Create your report in the Donations file. Create a subsummary part by DonatorID and put your summary field in it, along with any related fields you need, such as Donators::Name. Find all donations for the year, sort them by DonatorID, enter Preview Mode, and you should see the correct totals. Once it works, create a script to perform the steps for you.

[FM4me]

Thank you so much for your help, i am doing that now, and i am able to get the totals on each sponsor, but i want to use the grand totals of each of the sponsors on a thank you letter, specifying their total donations YTD (Year To Date) on another thank you letter report

thanks so much for your help

mike

[-Queue-]

Create a calculation of Year(DateDonation) in your Dontations file. Create a global number field and set it with the current year when you run the script to print the letters. Create a relationship where

globalField = YearCalc

AND

DonatorID = DonatorID

and a calc field of Sum(YourRelationship::AmountField) for the YTD total.