concatenating or otherwise summarizing Yes/No data in Access 2007

Triedtwice

New Member
Joined
Feb 17, 2014
Messages
31
I have true/false data (as yes/no check boxes) where my first field is my record name (record_name = "A" thru "Z") and the remaining fields are titled "One" thru "One_Hundred". The data are checked if my record_name tests positive for my field name criteria. For example: if record_name "B" contains "Two", then the box in field "Two" is checked in record_name="B". Record_name "B" tests positive for "Two", "Seventy_three", and "Ninety_nine". The example below pasted as True/False, but is applicable.
Record_nameOneTwoThreeFour
ATrueFalseFalseTrue
BFalseTrueFalseFalse
CFalseFalseFalseFalse
DFalseFalseTrueFalse
ETrueFalseTrueFalse
FFalseFalseFalseTrue

<tbody>
</tbody>

My question - is it possible to have a query concatenate or otherwise summarize all true occurrences, ignoring the false (unchecked boxes), for each record_name...returning something like:

"B" - Two, Seventy_three, Ninety_nine

Thanks!!!
 

Excel Facts

Move date out one month or year
Use =EDATE(A2,1) for one month later. Use EDATE(A2,12) for one year later.

Forum statistics

Threads
1,216,074
Messages
6,128,649
Members
449,462
Latest member
Chislobog

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top