Access report on booleans - TechRepublic
General discussion
March 21, 2002 at 01:04 AM
john_wills

Access report on booleans

by john_wills . Updated 24 years, 3 months ago

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?

This discussion is locked

All Comments