Summing multiple "if" statements

[Sre]

In my form I have 4 text boxes with "if" statements that returns a value if the user selects "issue" from a drop down menu. I would like to sum these values to a grand total.

Text Box 1 - =IIf([Results Source Folder Audit]="Issue","5")
Text Box 2 - =IIf([Results SCR Audit]="Issue","20")
Text Box 3 - =IIf([Results RMAL Audit]="Issue","5")
Text Box 4 - =IIf([Validation]="Issue","20")

I would like to create a grant total of the above text boxes. I tried this "=Sum(IIf([Results Source Folder Audit]="Issue","5")+IIf([Results SCR Audit]="Issue","20")+IIf([Results RMAL Audit]="Issue","5")+IIf([Validation]="Issue","20"))" I get this value - 520520. Example, If Issue was selected in all 4 text boxes the grand total should show 50.



Please help!!! Thanks in advance.

[ranman256]

you dont need any code.
you have a table with the 'options' and their values the user can pick.

[ISSUE], [valu]
the user picks the 'issue' but the box fills in the bound column of value.

zero vb code.
summing is done in a query.

[JoeM]

When you enclose numbers in quotes, they are treated as Text, not Numbers. So remove those quotes, i.e.

IIf([Results Source Folder Audit]="Issue",5)

[Sre]

When you enclose numbers in quotes, they are treated as Text, not Numbers. So remove those quotes, i.e.

IIf([Results Source Folder Audit]="Issue",5)

JoeM - Thank you that worked!!!!!