If statement with or - 2

[themich]

I'm in a fog and can't figure out how to pull amounts from a table where the id field = dues or uvac. My books arrive tonight, but I thought I'd try.

IF {CURRENT_PRT_CHECK_DEDUCT.Deduction_ID}="UVAC" OR "DUES"
THEN {CURRENT_PRT_CHECK_DEDUCT.Amount}
ELSE 0

 

[kray4660]

IF {CURRENT_PRT_CHECK_DEDUCT.Deduction_ID}="UVAC" OR {CURRENT_PRT_CHECK_DEDUCT.Deduction_ID}= "DUES"
THEN {CURRENT_PRT_CHECK_DEDUCT.Amount}
ELSE 0

 

[MCuthill]

Another Option (a little cleaner when more than one OR):

IF {CURRENT_PRT_CHECK_DEDUCT.Deduction_ID} in ["UVAC","DUES"] THEN {CURRENT_PRT_CHECK_DEDUCT.Amount} ELSE 0

Cheers!

Mike
---------------------------------------------------------------
"To be alive is to revel in the moments, in the sunrise and the sunset, in the sudden and brief episodes of love and adventure,
in the hours of companionship. It is, most of all, to never be paralyzed by your fears of a future that no one can foretell."