Conditional Paragraph

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
 
B

Brendan Reynolds

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