Need help with a report

[mzagorski1116@gmail.com]

I just converted a DB from Louts Approach to Access and need some pointers. The only thing I was able to convert was the DB table itself, reports did not convert. The Db is a simple fundraising collector fro my volunteer fire department... I have a list of names and addresses and I record what they give each year. I want a summary report that basically shows..

'year1' 'total amount' 'number returned' '% who donated'
'year2' 'total amount' 'number returned' '% who donated'
'year3' 'total amount' 'number returned' '% who donated'
'year4' 'total amount' 'number returned' '% who donated'


....
etc

In approach this was a piece of cake, in Access, for the life of me, I cannot figure out how to do this. Can someone point me to education/doc that will help do this. I've exhausted everything I was able to find after searching.

Thank you in advance!

[June7]

You want to aggregate data. Build aggregate query and/or use report Sorting & Grouping design features with aggregate calcs in textboxes. There are many tutorials online and I am sure books for you to learn these basics.

'% who donated' requires total of addresses to calculate with. This can be derived with a DCount() domain aggregate function or nested aggregate query.

If you want to provide db for analysis, follow instructions at bottom of my post.