Help counting multiple checkboxes in a form to make a total in a report

[firedog]

Hello

I’m learning Access 2007 by experimentation and by doing myself withou
the benefit of formal training, hence I’ve run into a stump (probably a
easy solution for some, but not for me … but I know I’ve come t
the right place …). I’m working on a database for police detective
that should track investigative progress on cases assigned to them

On my main data entry form there is a unique 14 digit “CaseNumber
for each investigative case. There will be as many as two individual
identifie
as “victims” and one other individual identified as
“witness”. There will be as many as three more individual
identified as “suspects”. Each of these individuals will b
identified by their names (first, middle, last, and surname (if any). For eac
of the three “suspect” individuals I have included a checkbox (Y/N
labeled “yes” and another checkbox (Y/N) labeled “no” t
identify any of the three individuals as having been arrested for tha
particular unique “CaseNumber”. There is other information to b
entered as well, but presently I am interested only in the individual
identified as “suspect”s

Here’s my difficulty: on one of the reports that I have been trying t
make I would like each of the “suspect” individuals with a checkmar
in the “yes” checkbox to be listed on their own line in the repor
along with some other supplementary information. If there is only on
“suspect” with a “yes” checkbox arrested in that case
he is listed on the report on his own line with that particula
“CaseNumber” along with the other supplementary information. (N
problem there....)

However, my question/difficulty is: if more than one “suspect” i
one particular case has been arrested with the “yes” checkbo
marked, how do I get each of these (“suspect” #2 and/or #3) to b
listed each on their own line using the same unique “CaseNumber”?
know that I could formulate a new report and list each individual (if only one
or all individuals (if more than one) that have been arrested on a single line
but that’s not what I want to do. I want my report to list them o
separate lines and to count them as a total number of individuals arrested

I apologize for the length of this request for assistance. I hope that i
adequately explains my problem. Rest assured that any assistance or advice wil
be greatly appreciated by this po’ boy. Thanks in advance

 

[Access Developer]

Can you afford to invest in a book or two? It's deucedly difficult to
stumble one's way through learning Access with only the occasional newsgroup
Q&A to help. The recent versions of Access have evolved so they are more
complex than Access once was, and, for one doing desktop or client-server
applications, the emphasis on web applications may be confusing.

"Access 2007 Inside Out" by Conrad and Viescas should be a good one -- and,
in the used book market, may not be very expensive.

Just from what you wrote, it's possible you may need to restructure your
data for an effective database, but as for displaying multiple related
records on a form, see help on Subform Control; or on report see Subreport
Control.

You don't need two Checkbox Controls or YesNo Fields for Yes/No answers --
you can select whether they should default to "yes" or "no" ("checked" means
"yes"; "unchecked" means "no").

 

[firedog]

Access Developer wrote on 03/26/2014 14:43 ET

Can you afford to invest in a book or two? It's deucedly difficult t
stumble one's way through learning Access with only the occasional newsgrou
Q&A to help. The recent versions of Access have evolved so they are mor
complex than Access once was, and, for one doing desktop or client-serve
applications, the emphasis on web applications may be confusing

"Access 2007 Inside Out" by Conrad and Viescas should be a good on
-- and
in the used book market, may not be very expensive

Just from what you wrote, it's possible you may need to restructure you
data for an effective database, but as for displaying multiple relate
records on a form, see help on Subform Control; or on report see Subrepor
Control

You don't need two Checkbox Controls or YesNo Fields for Yes/No answers -
you can select whether they should default to "yes" or "no
("checked" mean
"yes"; "unchecked" means "no")

Larry Linso
Microsoft Office Access MV
Co-Author, Microsoft Access Small Business Solutions, Wiley 201

"firedog" wrote i
messag
news

Thanks Larry.... for you quick response.... I'll look for the book yo
mentione
and spend more time in study and less in experimentation.... Thanks again fo
your advice and suggestions....

 

[Access Developer]

--
Larry Linson
Microsoft Office Access MVP
Co-Author, Microsoft Access Small Business Solutions, Wiley 2010

Thanks Larry.... for you quick response....
I'll look for the book you mentioned
and spend more time in study and less
in experimentation....
Thanks again for your advice and
suggestions....

You are most welcome. I got a lot of help 'along my way' and most only
wanted me to pass on the favor when I was able by offering help to someone
else -- so I'm still just paying them back.

Though I still invested in a few books, what you have been trying to do was
much simpler back in the days of Access 1.0, 1.1, and 2.0 -- the online Help
files contained every word of the Microsoft documentation for Access (yes,
'way back then, software came with one or several users' manuals).

Another book that was, in its day, considered 'the insider's real guide' to
Access was the "Access Developer's Handbook" by Litwin, Getz, et al -- the
publisher decided to stop publishing it after the 2002 edition, but it is
still full of good detailed, inside information for developers. And, as it
is out-of-date, may be inexpensive when available -- actuallly any edition
Access 2000 or later would be useful.

Best regards,
Larry