Conditional Paragraph

  • Thread starter Thread starter Arndres
  • Start date Start date
A

Arndres

I have a form letter report where I am trying to enter a paragraph if two
parameters in a field are not met. I am using the formula
=IIf([groupno]<>"M15625" Or <>"M51658","If you have chosen this option...")
But it does not seem to like the Or operator or the And operator. Please
Help Thanks
 
Arndres said:
I have a form letter report where I am trying to enter a paragraph if two
parameters in a field are not met. I am using the formula
=IIf([groupno]<>"M15625" Or <>"M51658","If you have chosen this
option...")
But it does not seem to like the Or operator or the And operator. Please
Help Thanks
Click to expand...


That would be ...

=IIf([groupno]<>"M15625" Or [groupno]<>"M51658","If you have chosen this
option...")

You have to include the complete condition on both sides of the "Or".
 
Back
Top