Percentage Calculation

J

Jen

Hi Guys,
I've got a Form which contains four bound fields set for numeric data
(only the numbers 0,1,2,or 3 will be entered). I'd like to create a fifth
unbound field which would calculate the sum of the four bound fields and give
the answer as a percentage of 12 (the highest possible total of the bound
fields)

Any help would be appreciated,
Thanks a lot,
Jen
 
A

Arvin Meyer [MVP]

= Format((NZ([Field1])+NZ([Field2])+NZ([Field3])+NZ([Field4]))/12,
"Percent")
 

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

Top