IIF statement question

[luvphx09]

I am trying to use this expression and run into a :banghead:

=Iif([Craft]="CraftName",[Field1]+[Field2]+[Field3],0)

I keep getting an error. What I am trying to do is when a specific craft is named, I want it to had Field1, Field2, and Field3 to get a total.

Any help is greatly appreciated!

 

[CJ_London]

what is your error? please provide both the error number and the error description

 

[luvphx09]

The error is that the calculation doesn't show up. It just says #Error inside the Field I am trying to get the calculation to work. There is no error number.

 

[CJ_London]

in that case, one of your names inside the square brackets is wrong - they need to be the same as the control names on your form or report

 

[George21]

Where are you putting the expression?