you might want to check out http://www.filemakerdonations.com/
You could use this as a base starter solution..
I don't think you would need another table.. you could simply mark the record as archived.
The other questions.. you can simply use summary fields in the same table. You could have some buttons on the layout that change the criteria.. ie.. a dropdown for all the months.. years.. etc..
Thank for the tip about the donations application from RCC. I've looked it over briefly but I don't find anything that resembles the historical data I'm looking for. I've seen several of the available "public domain" databases and I certainly appreciate what I'm able to learn from them. However, most of the "public" databases are very involved for those of us in the early or intermediate stages of learning FileMaker. So, I don't think I will be able to use the RCC donation application as a starter solution because there is a lot about it that I don't understand yet.
You also recommend that I don't use a separate table but that I can "simply mark the record as archived"? What does this mean?
Create a field called archive
when the archive field =1 , then this would mean you have archived it. So when your showing the user records you would show all records where archive is not =1.
you could then have an archive check box or another layout that would show the archive records.
If your looking for a logging.. Check out ultralog.
A summary report of all donations by a single donor, a group of donors or all donors over a specified date range can be pulled up and donation totals and other aggregate values can be shown broken down by week, month, year, or in many other ways by performing a find for the desired records and then sorting them on a layout designed to show the needed totals, averages, subtotals etc that you need for your report.
You may find this tutorial on summary reports useful: Creating Filemaker Pro summary reports--Tutorial