•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the MS Access and FileMaker Pro section within the Web Development category of DaniWeb, a massive community of 362,342 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 4,775 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our MS Access and FileMaker Pro advertiser:
Views: 13507 | Replies: 2
 |
•
•
Join Date: Sep 2006
Posts: 2
Reputation: 
Rep Power: 0
Solved Threads: 0
Newbie Poster
Microsoft Nested If statements with if, then, else I am trying to complete a deliverable with an acess database, below IS the formula that I used and it returned errors with the brackets and commas.
Age: IIF([P1]>12,0),IIF([P1]=12, 12-[P2]/12)ELSE, IIF([P1]<=4, 100%.
Age: IIF([P1]>12,0),IIF([P1]=12, 12-[P2]/12)ELSE, IIF([P1]<=4, 100%.
•
•
Join Date: Oct 2006
Location: Philippines but now in Saudi for International Work
Posts: 3
Reputation:
Rep Power: 0
Solved Threads: 0
Newbie Poster
Re: Microsoft Nested If statements with if, then, else •
•
•
•
Originally Posted by Bennita Martin 
I am trying to complete a deliverable with an acess database, below IS the formula that I used and it returned errors with the brackets and commas.
Age: IIF([P1]>12,0),IIF([P1]=12, 12-[P2]/12)ELSE, IIF([P1]<=4,
100%.
IF your are putting this expression inside your calculated control, you can revise this one because in immediate iif statement you cannot put else statement
IIF([P1]<=4,"100%",IIF([P1]>12,0),IIF([P1]=12, 12-[P2]/12, "this will handle your else condition" ))
•
•
Join Date: Mar 2007
Posts: 4
Reputation:
Rep Power: 0
Solved Threads: 0
Newbie Poster
•
•
•
•
Originally Posted by jlopez
IF your are putting this expression inside your calculated control, you can revise this one because in immediate iif statement you cannot put else statement
IIF([P1]<=4,"100%",IIF([P1]>12,0),IIF([P1]=12, 12-[P2]/12, "this will handle your else condition" ))
Hi...
u have problem in
IIF([P1]<=4,"100%",IIF([P1]>12,0,IIF([P1]=12, 12-[P2]/12, "this will handle your else condition" )))
|
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
•
•
•
•
•
•
•
•
DaniWeb MS Access and FileMaker Pro Marketplace
Linear Mode
•
•
•
•
access activation advertising ajax antivirus apple asp c# code computer console crack development drm exploit firefox game google internet ip ipod key linux mac malware microsoft mozilla mp3 news office open operating os pc photo product security software source spyware survey system upgrade virus vista web windows xbox 360 xp zune
- Using a switch statement with nested if/else statements (C++)
- Is there a simplest way to work this array problem? (C++)
- program w/ switch AND nested if. six error messages (C++)
- grades.java -- help!! (Java)
- writing a script (Shell Scripting)
Other Threads in the MS Access and FileMaker Pro Forum
- Previous Thread: Email direct from MS Access
- Next Thread: Access Date & Time Validation Question
