I have a table with a lot of boolean columns representing disabiities, e.g. visual, mobility. I want a report totalling the number of rows with each column set, somehting like this:
Visual 28
Mobility 23
It seems to me that I have to put a lot of SQL and DCount in VBA or the expression box and have a fixed-format report – the table does not know the meaning of each column. Any good ideas?
