IIF STATEMENTS

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

If Statements 2
IF STATEMENTS IN ACCESS 1
Multiple iif challenge 2
iif statement 5
I damn thee IIF statement..... 6
iif statements 2
Complex IIF Statement 1
Iif Statement help 6

Back
Top