Need Help with Conditional Expressions

[BluEydRdr2014]

I am trying to create a conditional expression in a table.

I am trying to say the following:
If [KIND] is "DEER", return "70", Otherwise, if [KIND] is "ELK", return a calculation that is [WEIGHT]*.7.

I am hung up on the calculation for the "ELK." If I write IIF([KIND]="DEER","70", IIF([KIND]="ELK", "[WEIGHT]*.7","OTHER")). I can enter the expression, but when I open my Form and select "ELK", the field that is supposed to have the calculation just shows [WEIGHT]*.7.....it does not perform the calculation.

What am I doing wrong?

Thanks for the help.



Crystal

[recyan]

IIF([KIND]="ELK", "[WEIGHT]*.7",

What happens, if you remove the double quotes

IIF([KIND]="ELK", [WEIGHT]*.7,

Thanks

[BluEydRdr2014]

It said my result type, such as binary or NULL, is not supported by this server.

I tried to make it simple and just do one True/Falsse, so I wrote: IIf([KIND]="DEER","70",[WEIGHT]*.7).

[recyan]

Does your [KIND] field have null or no values in one or more records ?

Thanks

[BluEydRdr2014]

Hmmm...no it is not. However, it is a drop down list made from another table. I wonder if that is the problem?

[recyan]

usually the experts advise us to avoid dropdown lists in tables. But feel that is not the problem.
Edit : Assume even the Weight Field has values in all its records.
Thanks

[recyan]

Check what happens if you use below :

IIF([KIND]="DEER","70", IIF([KIND]="ELK", Nz([WEIGHT],0)*.7,"OTHER"))

Thanks

[qa12dx]

requery the control that is supposed to show the results after update of cbo