My project for feeding people needs a few things

[BlueDishPhotography]

I started a database and have my form with check boxes to let me know who shows up for food each month. Each person that shows picks up for their family. My goal is to have a food pantry in the future. I am working on a report to let me know how many people showed up each month and how many people in each family we got food to all together. I also am going to add seniors/adults/children numbers so that when any grantors need to know the information they will have some good numbers. I'm also including volunteer hours on the report with the same kind of check boxes. I also want to include how much money we spent on the food, which should be easy. I hope this is something easy to help with. I haven't found the examples to get what I want anywhere. So I am now asking for help! The questions and problems I'm having are:

1) The report shows each checked box all the way down the page rather than a sum. I want it to be kind of plain and just numbers under their respective labels.
2) How can I reset all the check boxes in the form without unchecking each one manually after the report is made.
3) I also want a yearly report that shows the monthly numbers for each thing with possibly a grand total on the year.

thanks for any and all help!

 

[MarMo]

Hi BlueDishPhotography ,

You'd probably would be better of uploading a mock up db.
In that case people will be able to help you faster.

I can only help you with Q2 : the reset of the checkboxes on the form after the report is closed. (see attached database)
For the other 2 questions you'll need to provide a sample db with the reports.