Automatic Monthly Donations

[hamomianna]

I work for a small non-profit organization and recently made a database in Access 2010 to compile all of our donor/donation information. I made check boxes to mark whether a donation is restricted/not restricted, and monthly, but I'm trying to figure out if there's a way to designate a donation as monthly and have the program add in that amount each month - so I don't have to do it manually each time. I'm also very new to this sort of software, so any advice would help!

[pbaldy]

I would likely have two tables, one for donation transactions, and one for monthly donations (or it could be incorporated into a donors table). Each month, I'd run a process that created a donation transaction for every record in the monthly table. That could be automated fairly easily, or put behind a button to be done as desired. That would mean after a year, each person in the monthly table would have 12 transactions in the transaction table.