Is there a way to calculate and display the percentage of checked checkboxes on a report? I have a report that has a list of checkboxes some of which are checked and some are not. I would like the report to also display the percentage of checked boxes. Is this possible quickly and easily?
Is there a way to calculate and display the percentage of checked checkboxes on a rep (1 Viewer)
- Thread starter smroussel
- Start date
ill assume that the report is bound to a table? and the checkboxes are based on yes/no fields?
(big assumption i know)
then a select statement would give you the number of checked boxes
e.g. SELECT * WHERE check = yes
and the total value would be something like
SELECT * WHERE check = yes OR No
(big assumption i know)
then a select statement would give you the number of checked boxes
e.g. SELECT * WHERE check = yes
and the total value would be something like
SELECT * WHERE check = yes OR No
scottmvinovrski
Registered User.
- Local time
- Today, 03:40
- Joined
- Nov 8, 2006
- Messages
- 43
Place them in the Report Footer section of the report. Create a textbook and in the control source use =Count([Whatever your table name is]) to get the count of all the records in that report
My db is a survey designed to determine which employees need staff development in which areas. The employee checks off skills they cannot perform in several areas. I want a percentage of checked boxes(unknown skills) for each employee. I have a series of tables which are basically a txtbox for their ID number and a series of checkboxes(one for each skill) with a report based on each table. Each employee will get his report based on his survey answers. Each checkbox is not a record. Each checkbox is a field in a record. Will this still work?
