Check Box report problems

R

RTimberlake

I have a form/table that consists of multiple check boxes. I would like to
pull two reports. The first report needs to have the individuals name and a
list of the boxes that he/she has checked. I do not want a list of all of the
possibilities, just those that have been checked. The second report needs to
list the checkbox titles and the total number of "yes" that have been marked.
Is this even remotly possible. Please keep in mind that I am a newcomer to
Access and I don't understand some of the jargon that is used. Thank you for
your assisstance.
 
L

Larry Linson

Unfortunately, your un-normalized table design makes the first requirement
difficult. Data is not stored in Check Boxes -- the data from Check Boxes
may be stored in Yes/No fields.

The names of your Yes/No fields are, themselves, the "data" you want to
report. That can be done with VBA code, but I don't know a convenient
approach for doing so without VBA, or at least a somewhat complex structure
of text boxes in the report.

The Count builtin function in a Report Footer may serve to do what you want
in the second case. Create a tabular report with your table as its Record
Source. Move the Names up into the Report Header, delete the check boxes
from detail. Close up all sections except the Report Header and Footer (you
may have to open up the Report Footer). In the footer, below each Name,
create a Text Box and in each text box's Control Source specify:

=Sum(Abs([<name>]) where <name> is the name of your Yes/No field.

Larry Linson
Microsoft Access MVP
 
Top