info
Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Help counting multiple checkboxes in a form to make a total in a report
18 views
Skip to first unread message
firedog
Mar 26, 2014, 11:13:14 AM3/26/14
to
Hello,
I’m learning Access 2007 by experimentation and by doing myself without
the benefit of formal training, hence I’ve run into a stump (probably an
easy solution for some, but not for me … but I know I’ve come to
the right place …). I’m working on a database for police detectives
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 individuals
identified
as “victims” and one other individual identified as a
“witness”. There will be as many as three more individuals
identified as “suspects”. Each of these individuals will be
identified by their names (first, middle, last, and surname (if any). For each
of the three “suspect” individuals I have included a checkbox (Y/N)
labeled “yes” and another checkbox (Y/N) labeled “no” to
identify any of the three individuals as having been arrested for that
particular unique “CaseNumber”. There is other information to be
entered as well, but presently I am interested only in the individuals
identified as “suspect”s.
Here’s my difficulty: on one of the reports that I have been trying to
make I would like each of the “suspect” individuals with a checkmark
in the “yes” checkbox to be listed on their own line in the report
along with some other supplementary information. If there is only one
“suspect” with a “yes” checkbox arrested in that case,
he is listed on the report on his own line with that particular
“CaseNumber” along with the other supplementary information. (No
problem there....).
However, my question/difficulty is: if more than one “suspect” in
one particular case has been arrested with the “yes” checkbox
marked, how do I get each of these (“suspect” #2 and/or #3) to be
listed each on their own line using the same unique “CaseNumber”? I
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 on
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 it
adequately explains my problem. Rest assured that any assistance or advice will
be greatly appreciated by this po’ boy. Thanks in advance
I’m learning Access 2007 by experimentation and by doing myself without
the benefit of formal training, hence I’ve run into a stump (probably an
easy solution for some, but not for me … but I know I’ve come to
the right place …). I’m working on a database for police detectives
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 individuals
identified
as “victims” and one other individual identified as a
“witness”. There will be as many as three more individuals
identified as “suspects”. Each of these individuals will be
identified by their names (first, middle, last, and surname (if any). For each
of the three “suspect” individuals I have included a checkbox (Y/N)
labeled “yes” and another checkbox (Y/N) labeled “no” to
identify any of the three individuals as having been arrested for that
particular unique “CaseNumber”. There is other information to be
entered as well, but presently I am interested only in the individuals
identified as “suspect”s.
Here’s my difficulty: on one of the reports that I have been trying to
make I would like each of the “suspect” individuals with a checkmark
in the “yes” checkbox to be listed on their own line in the report
along with some other supplementary information. If there is only one
“suspect” with a “yes” checkbox arrested in that case,
he is listed on the report on his own line with that particular
“CaseNumber” along with the other supplementary information. (No
problem there....).
However, my question/difficulty is: if more than one “suspect” in
one particular case has been arrested with the “yes” checkbox
marked, how do I get each of these (“suspect” #2 and/or #3) to be
listed each on their own line using the same unique “CaseNumber”? I
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 on
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 it
adequately explains my problem. Rest assured that any assistance or advice will
be greatly appreciated by this po’ boy. Thanks in advance
Access Developer
Mar 26, 2014, 3:43:34 PM3/26/14
to
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").
--
Larry Linson
Microsoft Office Access MVP
Co-Author, Microsoft Access Small Business Solutions, Wiley 2010
"firedog" <nospam_d...@wildblue.net.invalid> wrote in message
news:AK2dnSZzMsgXc6_O...@giganews.com...
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").
--
Larry Linson
Microsoft Office Access MVP
Co-Author, Microsoft Access Small Business Solutions, Wiley 2010
"firedog" <nospam_d...@wildblue.net.invalid> wrote in message
news:AK2dnSZzMsgXc6_O...@giganews.com...
firedog
Mar 27, 2014, 3:07:24 PM3/27/14
to
Access Developer wrote on 03/26/2014 14:43 ET :
> 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").
>
> 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").
>
> Larry Linson
> Microsoft Office Access MVP
> Co-Author, Microsoft Access Small Business Solutions, Wiley 2010
>
> "firedog" wrote in
> Microsoft Office Access MVP
> Co-Author, Microsoft Access Small Business Solutions, Wiley 2010
>
> message
> news:
>>
>> However, my question/difficulty is: if more than one “suspect” in
>> one particular case has been arrested with the “yes” checkbox
>> marked, how do I get each of these (“suspect” #2 and/or #3) to be
>> listed each on their own line using the same unique “CaseNumber”?
>> I
>> 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 on
>> 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 it
>> adequately explains my problem. Rest assured that any assistance or advice
>> will
>> be greatly appreciated by this po’ boy. Thanks in advance
>>
>
Thanks Larry.... for you quick response.... I'll look for the book you
>> However, my question/difficulty is: if more than one “suspect” in
>> one particular case has been arrested with the “yes” checkbox
>> marked, how do I get each of these (“suspect” #2 and/or #3) to be
>> listed each on their own line using the same unique “CaseNumber”?
>> I
>> 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 on
>> 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 it
>> adequately explains my problem. Rest assured that any assistance or advice
>> will
>> be greatly appreciated by this po’ boy. Thanks in advance
>>
>
mentioned
and spend more time in study and less in experimentation.... Thanks again for
your advice and suggestions....
Access Developer
Mar 27, 2014, 3:19:40 PM3/27/14
to
--
Larry Linson
Microsoft Office Access MVP
Co-Author, Microsoft Access Small Business Solutions, Wiley 2010
"firedog" <nospam_d...@wildblue.net.invalid> wrote
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....
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
0 new messages