G
goodkitty
I have a database that has on one of the tables a selection of 19 checkboxes
(for Yes/No Fields). I want to create a report that allows me to just have a
count of how many yes's there are in each field, that meet a second criteria.
I don't want or need the entire list of checkboxes showing on the report -
just a count of how many yes's there are in field one, how many yes's in
field 2, how many yes's in field 3, etc... through to the last field. I've
been searching high and low for the answer. I have created a query for each
of the different fields to separate out the ones meeting criteria - but that
is 19 queries, and I can't get them into the same report nor can I get them
to summarize to just the count. I looked into exporting to excel and then let
excel do it - but can't figure that out either. I'm a novice at Access so
need step by step instructions if you know of a way to do this (including
what properties may need changed in a report field).
(for Yes/No Fields). I want to create a report that allows me to just have a
count of how many yes's there are in each field, that meet a second criteria.
I don't want or need the entire list of checkboxes showing on the report -
just a count of how many yes's there are in field one, how many yes's in
field 2, how many yes's in field 3, etc... through to the last field. I've
been searching high and low for the answer. I have created a query for each
of the different fields to separate out the ones meeting criteria - but that
is 19 queries, and I can't get them into the same report nor can I get them
to summarize to just the count. I looked into exporting to excel and then let
excel do it - but can't figure that out either. I'm a novice at Access so
need step by step instructions if you know of a way to do this (including
what properties may need changed in a report field).