Go Back   Access World Forums > Microsoft Access Discussion > Reports

Thread Tools Rate Thread Display Modes
Old 09-29-2014, 01:25 PM   #1
Newly Registered User
Join Date: Sep 2014
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
BlueDishPhotography is on a distinguished road
Question My project for feeding people needs a few things

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!

BlueDishPhotography is offline   Reply With Quote
Old 10-03-2014, 05:09 AM   #2
Newly Registered User
Join Date: Jul 2014
Location: Belgium
Posts: 7
Thanks: 0
Thanked 0 Times in 0 Posts
MarMo is on a distinguished road
Re: My project for feeding people needs a few things

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.
Attached Files
File Type: accdb ResetChkBoxesOnForm.accdb (1.11 MB, 39 views)
MarMo is offline   Reply With Quote

check boxes , forms , reports

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
feeding a value list, not a field, to sql st delikedi Queries 7 08-13-2012 10:51 AM
Feeding data to the right bits tassiegal Reports 16 02-05-2012 10:00 PM
letter feeding from DB IOI Tables 9 10-16-2007 07:16 AM
Many-Many Form Multiple People to One Project ramasule Tables 2 03-14-2007 05:45 PM
feeding QBF results to a report? datacontrol Forms 6 09-09-2003 07:40 AM

All times are GMT -8. The time now is 06:13 AM.

Microsoft Access Help
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post

Sponsored Links

Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World