How do i use the IIF query for my equation.

[pekimojoe]

Hello guys, new to the forum and access...

Have a basic question that i cant seem to work out... Basically i want to achieve a calculated field in a query IF a condition is met.

The question i want to answer is... IF a [field] = null (no value) then i want to subtract a [field] from another [field].

Example: If [Field1]Is Null, [Field2]-[Field3]



Thanks in advance!

[Bob Fitz]

Take a look at the IIF() function: https://support.office.com/en-gb/art...ad=GB&fromAR=1
Maybe something like:
Result:IIF(IsNull([Field1]), [Field2]-[Field3],"")