concatenating or otherwise summarizing Yes/No data in Access 2007

[Triedtwice]

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.

A	True	False	False	True
B	False	True	False	False
C	False	False	False	False
D	False	False	True	False
E	True	False	True	False
F	False	False	False	True

<tbody>
[TH="bgcolor: #c0c0c0"] Record_name [/TH]
[TH="bgcolor: #c0c0c0"] One [/TH]
[TH="bgcolor: #c0c0c0"] Two [/TH]
[TH="bgcolor: #c0c0c0"] Three [/TH]
[TH="bgcolor: #c0c0c0"] Four [/TH]

</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!!!