IIF STATEMENTS

S

Sarah_Lecturer

Hi!

I have a problem associated with IF Statements in Access.

I have three fields,

Results, Moderation and Proxy

I want to add the following IF statement to a field on a form to display the
correct answer:

If Results =P and Moderation =P then Complete OR If Results = P and Proxy =
P then Complete, Otherwise Incomplete

Hope this makes sense

Thanks in advance

Sarah
 
S

Steve Schapel

Sarah,

You would do this in an unbound textbox on the form. Set its Control
Source to...
=IIf([Results]="P" And ([Moderation]="P" Or
[Proxy]="P"),"Complete","Incomplete")
 
Top