IF STATEMENTS IN ACCESS

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

Guest

Hi,

I have a problem! I have been trying to add an IF Statement to a field on a
form in Access but it does not appear to be working.

I have three fields

Result, Moderation and Proxy

I want the IF statement to do the following

If the Result and the Proxy = P then Complete OR If the Result and the
Moderation = P then Complete Otherwise Incomplete.

IF anyone has any suggestions - would really appreciate it!

Thanks in advance,

Sarah xxx
 
You should use the iif statement

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

put this line in the ControlSource Property of the new field
 
Back
Top