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?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Format a Percent 4
Format a percent 7
Formatting a percent field 1
Format a percent field 1
Access Test if value is less than percent 0
Percent Format: Allow user to type Percent, not decimal? 3
Percent problems 4
Percent problem again 2

Back
Top