Multiple values in Percent Calculation

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to find a compliance percent value based upon 72 individual yes/no fields, named Val1....Val72. The fields appear on a form, and when a field is updated, I want to be able to recalc the compliance percent(the number of yes's divided by the total number of fields with entries. Is there an easy way?
 
The easy way is to create a related table with one field to distinguish what
it is, and another for the Yes/No value (and probably a foreign key to the
first table). That way you can just count (or sum) the yes no fields.

If you do not want to do it the relational way, then you have to enter the
name of each of your 72 columns manually in the expression.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

NeedinHelp said:
I am trying to find a compliance percent value based upon 72 individual
Click to expand...
yes/no fields, named Val1....Val72. The fields appear on a form, and when a
field is updated, I want to be able to recalc the compliance percent(the
number of yes's divided by the total number of fields with entries. Is
there an easy way?
 
Back
Top