Access 2007 FAQ
How can I get a report in the Charitable Contributions template of each Contributor's total donations?
(Abbreviated text of question from newsgroup post)
"I've input all my data onto a Charitable Contributions template from the Office website, and now am attempting to print statements for each contributor for tax purposes. When I pull up a specific contributor, I can click on the "donations" tab on their record and see all the donations they've made through the year, I just can't get it to print. I've tried a query, which has seemed to foul things up even more and I can't find the ForceNewPage property that I was hoping would solve my problems and make the reports print like a charm."
There are several ways to approach this issue, but I'll just present two.
First, you can open the "All Donations" report from the Donations List form. To get there, click the Donations buttons on the main form - Charitable Contributions Home. Next, click the Report All Donations button on the Donations List form. This report, All Donations, shows all the donations by all contributors across all the different campaigns. You can easily filter this report to show only one specific contributor by right-clicking on the specific contributor's name and selecting "Equals <the name here>" from the filter menu. Access now displays only the donations for that contributor and you can print that.
Second, you can build a specific report for this purpose. To make things easier for you, I built one that does this functionality. You can download this ContributorDonationsReport.zip file to your local machine and then unzip the database file. Next, open your Charitable Contributions database and import this report into your database from the sample file. Assuming you haven't made any modifications to the tables in the template, this report should function "right out of the box." Open the report to see all the donations first grouped by contributor and then by campaign. The report also displays subtotals for each campaign and a grand total of all donations. If you open the report in Report View, you'll see hyperlinks on some of the fields to open the corresponding data entry forms. If you open the report in Print Preview, you'll notice that Access puts a page break after each specific contributor.
I hope that helps.
See more tips and tricks like this in our book: Microsoft Office Access 2007 Inside Out
Back to FAQ main page