Information from a form's checkboxes to a line in a report

[BenHarper]

I have a number of checkboxes in a form and table that I want to have a report interpret into text.
ie: if the 'Autism' box is checked, I want the report to display the word 'Autism' and so on.
Also, there are as many as 8 boxes, and I want all of the boxes that are checked to show text in one line on the report (ie: if Autism, Down Syndrome and Premature are checked I want the output to be 'Autism, Down Syndrome, Premature' all in one line.
Again, my SQL knowledge is limited so don't be afraid to dumb it down.

Much Obliged

 

[Carol]

The easiest way to accomplish this is by doing it through a query.
For each check box, make an additional field within the query to hold the text answers, as follows:
CheckBox1: IIf([CheckBox1]="1","Autism")
Then, create an additional field within the query and cancentrate all the CheckBox fields as follows:
Answer: [CheckBox1] & ", " & [CheckBox2] and so on.
Replace the field names as necessary. Use the Answer field as the field name within your report.
Good luck

 

[Neo90815]

Ben,

Did that work for? I'm trying to do the same thing.

Noe