I NEED HELP PRINTING A REPORT WITH CHECKBOXES

[chubby]

I want to print a report that comes from a query that contains 15 yes/no check boxes questions. Each record may have up to three check boxes. My problem is, how can I print only the check boxes that are checked and not all 15 every time. It would reduce to size of my report and only contain the needed information.

example: (Query)
Names:
Age:
1. Married: yes/ no
5. Have kids: yes/ no
12. Have a car: yes/no
15. Have a pet: Yes/no

(Report)

Name: John Doe Age: 21 Married Kids Car
y y y

 

[ToeShot]

Could you Create a query that has all of the check boxes marked to be returned then create another query that returns all the check boxes are not marked.

Then Build a report off each query

 

[kstearns04]

Do you actually need the y's if the text information is being displayed? Are they in specific columns? You can create the string with

INFO: IIf([Married]=True,"Married&quot & IIf([Kids]=True," Kids&quot...)

in your recordsource. Then display the y's within the proper columns if necessary.

 

[Guest_imported]

How about creating 15 new fields where you set your no values to Null and keep the yes values. This will only display whatever you happen to set your yes values to (Yes, Y, or whatever).