=IIf statement with compounds conditions with different fields in same record

[Bearcreek]

Partial record in MS Access 365 running under windows 10 using Parallels for Windows on iMac with Intel I7

-------------------------------------------------------------------------------------------------------
| ID | transName | transDate | transType | transAmount |


--------------------------------------------------------------------------------------------------------
| 11561 | 129 | 1/31/2014 | xfer | $1,000.00 |
--------------------------------------------------------------------------------------------------------
=IIf([transType] = "xfer" And [transAmount] > 0, [transAmount]) does not yield anything in the unbound textbook containing the above statement. No input is desired if the compound condition is false.

Any assistance is appreciated.

[ssanfu]

The syntax if the Immediate If function is

IIF (condition, TRUE, FALSE)

You are missing the FALSE option.

condition = [transType] = "xfer" And [transAmount] > 0

if condition is TRUE then return [transAmount]
else if condition is FALSE return 0 ???




Maybe

=IIf([transType] = "xfer" And [transAmount] > 0, [transAmount], 0)

or
=IIf([transType] = "xfer" And [transAmount] > 0, [transAmount],"")

or
=IIf([transType] = "xfer" And [transAmount] > 0, [transAmount], NULL)

[pbaldy]

FYI I moved your thread to a more appropriate forum. Welcome to the site!