if statement 1

[nike2000]

Hi,
I am writing a report that one Control Box requires an If Statement.

The following four fields have a value of Yes or No.

Migrate
Middle Office Check
Trader Check Check
Vanilla Trade Check

I would like to have an If statment that would return the value of 'Yes' if all the above fields have 'Yes' displayed in them.
If 'No' appears in any I would like the result to be 'No'
Only all of them must be 'Yes' to display 'Yes'.

Your help is appreciated.
Thanks for taking a look.
Nike

 

[Aubs010]

in the control source for the text box you want to have "Yes" or "No" to appear in, you need this:

(I am assuming that you have "Yes" or "No" in the fields:

=IIF([Migrate]="Yes" AND [Middle Office Check]="Yes" AND [Trader Check Check]="Yes" AND [Vanilla Trade Check]="Yes","Yes","No")

Alternatively, if the fields are check boxes, where <tick> = &quot;Yes&quot; and <no_tick> = &quot;No&quot;, then this will work:

=IIF([Migrate]=True AND [Middle Office Check]=True AND [Trader Check Check]=True AND [Vanilla Trade Check]=True,"Yes","No")

Hope one of these helps
Aubs

 

[nike2000]

It worked perfectly.
Thank you for your help.
Nike