Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
if statement with multiple and
i need to put this long if statement in and it has multiple ands, is there a
way to do this? IF {R_HistoryStatement.SubCode} 0 AND {R_HistoryStatement.TransactionCode} = 75 THEN {R_HistoryStatement.FeeDesc} + ' Assess' ELSE IF {R_HistoryStatement.SubCode} 0 AND {R_HistoryStatement.TransactionCode} = 76 THEN {R_HistoryStatement.FeeDesc} + ' Waive' ELSE IF {R_HistoryStatement.SubCode} 0 AND {R_HistoryStatement.TransactionCode} = 77 THEN {R_HistoryStatement.FeeDesc} + ' Assess' ELSE IF {R_HistoryStatement.SubCode} 0 AND {R_HistoryStatement.TransactionCode} = 78 THEN {R_HistoryStatement.FeeDesc} + ' Waive' ELSE IF {R_HistoryStatement.SubCode} 0 AND {R_HistoryStatement.TransactionCode} = 320 THEN {R_HistoryStatement.FeeDesc} + ' Payment' ELSE IF {R_HistoryStatement.SubCode} 0 AND {R_HistoryStatement.TransactionCode} = 330 THEN {R_HistoryStatement.FeeDesc} + ' Payment' ELSE IF {R_HistoryStatement.SubCode} 0 AND {R_HistoryStatement.TransactionCode} = 340 THEN {R_HistoryStatement.FeeDesc} + ' Payment' ELSE IF {R_HistoryStatement.SubCode} 0 AND {R_HistoryStatement.TransactionCode} = 720 THEN {R_HistoryStatement.FeeDesc} + ' Disburse' ELSE IF {R_HistoryStatement.SubCode} 0 AND {R_HistoryStatement.TransactionCode} = 730 THEN {R_HistoryStatement.FeeDesc} + ' Disburse' Else if {R_HistoryStatement.TransactionCode} = 511 AND {R_HistoryStatement.SubCode} 0 Then {R_HistoryStatement.ETDesc} + ' Bill 1' Else if {R_HistoryStatement.TransactionCode} = 512 AND {R_HistoryStatement.SubCode} 0 Then {R_HistoryStatement.ETDesc} + ' Bill 2' Else if {R_HistoryStatement.TransactionCode} = 513 AND {R_HistoryStatement.SubCode} 0 Then {R_HistoryStatement.ETDesc} + ' Bill 3' Else if {R_HistoryStatement.TransactionCode} = 514 AND {R_HistoryStatement.SubCode} 0 Then {R_HistoryStatement.ETDesc} + ' Bill 4' Else if {R_HistoryStatement.TransactionCode} = 530 AND {R_HistoryStatement.SubCode} 0 Then {R_HistoryStatement.ETDesc} + ' Disb' Else if {R_HistoryStatement.TransactionCode} = 531 AND {R_HistoryStatement.SubCode} 0 Then {R_HistoryStatement.ETDesc} + ' Addl Prem' ELSE {R_HistoryStatement.Description} |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Possible BUG: Multiple HTTPrequests send from one includetext statement | Mailmerge | |||
Multiple If... Then Statement in Word 2003 | Mailmerge | |||
Multiple "or" in "If Statement" | Mailmerge | |||
IF Statement using multiple Expressions with Bolean | Mailmerge | |||
Multiple docs open multiple words | New Users |