iif statement in access query

[frustratedwithaccess]

Hello All,

I am attempting to create an IIF statement in an access query.

What would my statement look like if trying to do the following with 4 fields?

field1, field2, field3, field4

- field4 should be a calculation based on field1, field2 and field3

If field 1 equals 0, then field 4 should = field2 + field3


If field 1 equals 1, then field 4 should = null

Any ideas?

Thanks!

[June7]

What have you tried and why doesn't it work - error message, wrong results, nothing happens? Can field1 have values other than 0 or 1?

Is field4 actually in the table? Is this a Calculated type field?

IIf([Field1]=1, Null, [field2] + [field3])

[frustratedwithaccess]

field 1 is either a 0 or 1.

results have shown null in cells, or "error".

field 4 is supposed to be a calculated field (field2 + field3, depending on if field1 is a 0 or 1... if it's a 0, then I want the values of field2 and 3 added together for the sum in field 4)

[frustratedwithaccess]

this is what I am trying:

field4: IIF([field1]=1,NULL, [field2] +[field3]

which keeps giving me "error"

[June7]

This is the second thread today dealing with expression in Calculated field that works in 2010 but not in 2013. The IIf() works for me.

Field1 is a number type?

Try the expression in query instead of table.

[istari88]

Is the problem solved by closing the IIF parenthesis?

[June7]

Good catch, istari.

Missing paren at end of expression.