Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #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}
 
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Possible BUG: Multiple HTTPrequests send from one includetext statement Oliver Mailmerge 2 April 18th 05 09:46 AM
Multiple If... Then Statement in Word 2003 Sue Hargrave Mailmerge 1 February 26th 05 10:48 PM
Multiple "or" in "If Statement" WordUser Mailmerge 2 February 4th 05 02:02 PM
IF Statement using multiple Expressions with Bolean Viperpurple Mailmerge 3 December 19th 04 02:33 PM
Multiple docs open multiple words Ron Smith New Users 2 December 11th 04 09:21 PM


All times are GMT +1. The time now is 06:18 AM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"