View Single Post
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Charles
 
Posts: n/a
Default 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}