Subreport - Y/N

[Lori]

I have a report for contacts and a subreport for contact types. The
subreport has nothing but Y/N buttons. I would like only those marked true
to appear, currently all the boxes appear even if not true. There is no can
grow or can shrink on the format tab of the properties, so can someone tell
me how I might do this?

Some contacts will only have one box marked true and others will have several.

 

[Duane Hookom]

You could normalize your Y/N fields using a union query. Then set the
subreport to multi-column to display the selected types across.

If you can't figure this out, come back with the fields in your subreport
record source.