report help

N

Nichole

i have a very small database. my form/table consists of contact info and 5
checkboxes which i am using to track items (ie, each entry would get a check
box if they are volunteers, donating $$, thank you sent etc.) i want a
report to run for each of the 5 check box items that will list only those
contacts that do have a check (ie. i want a list of all the people donating
money, a list of all the people volunteering, all the people that were sent a
thank you). i'm not sure if i need to change something in the report itself
or set up a query, i'm very new to this product. any precise help you can
provide i would greatly appreciate it.
TY in advance.
 
J

John Vinson

i have a very small database. my form/table consists of contact info and 5
checkboxes which i am using to track items (ie, each entry would get a check
box if they are volunteers, donating $$, thank you sent etc.) i want a
report to run for each of the 5 check box items that will list only those
contacts that do have a check (ie. i want a list of all the people donating
money, a list of all the people volunteering, all the people that were sent a
thank you). i'm not sure if i need to change something in the report itself
or set up a query, i'm very new to this product. any precise help you can
provide i would greatly appreciate it.
TY in advance.
Click to expand...

Set up a Query based on the Table; select all of the fields.

On the Criteria line under the (say) Volunteering checkbox, type the
word True.

Base a Report on this query. It will show only the people who
volunteered.

John W. Vinson[MVP]
 
N

Nichole

Perfect, that was easy even for me, but how to do i get this report without
the check box on it. i want just the list of names.
Thanx
 
J

John Vinson

Perfect, that was easy even for me, but how to do i get this report without
the check box on it. i want just the list of names.
Thanx
Click to expand...

Open the Report in design view; select the checkbox; press the Delete
key on your keyboard. It can be in the Query without being on the
Report!

John W. Vinson[MVP]
 
Top