Using check boxes as a control for displaying another field.

[carcement]

I have a table with a list of Brands in the first column followed by multiple Yes/No columns - each column after the brands represents a zone. If the checkbox in the zone is ticked, the Brand can be sold in that Zone. I'm attempting to make a simple report in order to share this information, but I'd like the report to be separated into Zones with the brand name listed only if the checkbox is ticked.



I've included a sample database with an example of the table: Help_Database.accdb

My thoughts are that I would create groups in the report based on the zone, but I'd prefer not to have the checkboxes show - just the brand name if the corresponding check box is ticked. Is this possible with the way I have this table set up or should I scrap this table and list the brands themselves under the zone headers?

[June7]

This is not a normalized data structure and will cause you frustrations.

Cannot do 'grouping' by Zone in report using multiple fields.

The alternative you describe is also not a normalized structure.

The db has only the one table. What is your ultimate goal with this database? If the one table is all you will have, might as well be an Excel spreadsheet.