If 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
 
You should use the iif statement

IIf([Results] ="P" and ([Moderation] ="P" Or [Proxy] = "P"), "Complete",
"Incomplete")
 
Thanks ever so much for your help!

Works perfectly now!

Thanks

Sarah x

Ofer said:
You should use the iif statement

IIf([Results] ="P" and ([Moderation] ="P" Or [Proxy] = "P"), "Complete",
"Incomplete")


Sarah_Lecturer said:
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
Click to expand...
Click to expand...
 
Back
Top