Conditional Paragraph

[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

 

[Brendan Reynolds]

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

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".