Hi,
This questions relates to counting check boxes stored in a table and presenting those totals in a report.
I would like my report to look like this:
Total check boxes TRUE Category 1 5 Category 2 4 Category 3 2 Category 4 3 Category 5 1
Each record in the main table has a value for at least one of these 5 categories.
Is it possible to setup a count in the report design or do I need to create a query that would summarise the totals first? I basically want Access to count all records that are TRUE.
Does this sound like check boxes have been setup correctly? What is the best way to store the values of check boxes?
Thank you.
Cheers
Chris