|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
June 17th, 2005, 10:27 AM
|
|||
|
|||
IIF STATEMENTS
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 
|
|
#2
June 17th, 2005, 10:44 AM
|
|||
|
|||
|
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") -- Steve Schapel, Microsoft Access MVP Sarah_Lecturer wrote: 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
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| IIf statements | GOL | General Discussion | 3 | February 21st, 2005 04:05 PM |
| Nested IF statements | John Simons | Worksheet Functions | 14 | February 16th, 2005 06:17 AM |
| adding iif statements | luscioussarita | Setting Up & Running Reports | 6 | December 20th, 2004 06:10 PM |
| multiple sql statements in OLE DB command | Jerry Nettleton | Running & Setting Up Queries | 2 | June 18th, 2004 04:58 AM |
| IF Statements | Bill | Worksheet Functions | 8 | February 6th, 2004 06:46 PM |
Linear Mode
