Hi all,

I would like to know how do you go about calculating percentages in Access.

For example, in a form I have 3 combo boxes with drop down menus where a user can select "Yes" or "No" and a text box where I will calculate a percentage. What I am looking for is something like this:

If combo1 = "yes" then percentagebox = 1 / 3 * 100

ElseIf combo1 AND combo2 = "Yes" then percentagebox = 2 / 3 * 100

ElseIf combo1 AND combo2 AND combo3 = "Yes" then percentagebox = 3 / 3 * 100.

Can anyone tell me how can I go about creating and calculating percentages such as this in Access? I appreciate any help.

Thanks