Obtaining a percentage off of Yes/No?

[robk5787]

Is there a way to get a percentage based number off of information entered utilizing the yes/ no check boxes rather than a numerical input value. I have users entering audit information by checking a yes/no box, and would like to be able to run a report showing efficiency. The only way I would be able to do this is by getting a percentage effective rate off the check boxes. I appreciate all help with this matter ahead of time. Thanks!

 

[Mile-O]

=DCount("CheckBoxField", "MyQuery", "CheckBoxField = True")/DCount("CheckBoxField", "MyQuery")

 

[robk5787]

Thanks for the help. I will gve this a try.