I am building a query and want to show only the checkbox's that have been checked. What kind of validation rule/formula can I make so I can create my own column title and then show the name of the checkbox's checked? Here is a picture of what it currently looks like:

http://i47.tinypic.com/2qtia1i.png

Instead of having all the checkbox name column's showing up I want to create just one column that shows all the checkbox's checked. How can I do this? For example, in the picture in the second row only carlessDriv and speeding box's are checked, but all others are still visible. I want to create one entry that will show only: carlessDriv, speeding

Thanks

In your query for the check box, in the Criteria put either "True"or -1, either will return the check boxes that are checked.

thanks, but there are many rows with checkbox's that I have. if I set them all to false then only one row will show up. I want to replace all the current columns such as carlessDriv and speeding with just one. Below this column it will show the name of the checkbox's that are checked.Any idea?

Is the query in the attached the sort of thing you are looking for?

thank you soo much. This is exactly what I was looking for:D