We help IT Professionals succeed at work.

Check out our new AWS podcast with Certified Expert, Phil Phillips! Listen to "How to Execute a Seamless AWS Migration" on EE or on your favorite podcast platform. Listen Now

x

Grouping and Report

pdvsa
pdvsa asked
on
Medium Priority
278 Views
Last Modified: 2012-05-11
Experts, I would like to modify the below to include an "OR" on the "Awaiting Amend Approval by Bank".  Can I include something like this:
this is wrong though:
MyGroup: IIf(IsNull([tblLCAmendHistory].[DateAmendApprovedByBank]) OR [tblLCAmendHistory].[WaitingBeneConsent])  ]),"Awaiting Amend Approval by Bank","Recently Approved Amend by Bank")

this is the original (no or stmnt):
MyGroup: IIf(IsNull([tblLCAmendHistory].[DateAmendApprovedByBank]),"Awaiting Amend Approval by Bank","Recently Approved Amend by Bank")

thank you
Comment
Watch Question

pdvsaProject finance

Author

Commented:
oops the [WaitingBeneConsent] would need to have  a condition of true or Yes for the "Awaiting Amend Approval by Bank" part.
Jeffrey CoachmanMIS Liason
CERTIFIED EXPERT
Most Valuable Expert 2012

Commented:
The basic syntax is:

IIF((Something=X) Or (Something=Y),WhatToDoIfEitherIsTrue,WhatToDoIfNietherIsTrue)

Sample Query is attached
Access-EE.mdb
pdvsaProject finance

Author

Commented:
Boag2000:  I have an error here and wonder if you see it.  I added the second IIF and the IsNOTnull.  It says I have too many arguments.  
thank you.

MyGroup: IIf(IsNull([tblLCAmendHistory].[DateAmendApprovedByBank]) Or IIF(IsNotNull([tblLCAmendHistory].[WaitingBeneConsentYN]),"Awaiting Amend Approval by Bank","Recently Approved Amend by Bank")
Jeffrey CoachmanMIS Liason
CERTIFIED EXPERT
Most Valuable Expert 2012

Commented:
IIf(IsNull([tblLCAmendHistory].[DateAmendApprovedByBank]) Or IIF(IsNotNull([tblLCAmendHistory].[WaitingBeneConsentYN]),"Awaiting Amend Approval by Bank","Recently Approved Amend by Bank")

Did you examine the sample I posted?

As far as I can tell (and based on the working syntax and sample I posted0, you don't need the second IIF

IIf(IsNull([tblLCAmendHistory].[DateAmendApprovedByBank]) Or (IsNotNull([tblLCAmendHistory].[WaitingBeneConsentYN]),"Awaiting Amend Approval by Bank","Recently Approved Amend by Bank")
pdvsaProject finance

Author

Commented:
Ok Thank you sir...will test this.  Have been out of pocket and willbe nxt few days.. Catch up soon...
Jeffrey CoachmanMIS Liason
CERTIFIED EXPERT
Most Valuable Expert 2012

Commented:
Wait, ...what is "IsNotNull"?

I think you might need this:

IIf(IsNull([tblLCAmendHistory].[DateAmendApprovedByBank]) Or (Not IsNull([tblLCAmendHistory].[WaitingBeneConsentYN]),"Awaiting Amend Approval by Bank","Recently Approved Amend by Bank")
pdvsaProject finance

Author

Commented:
I see ... Thanks for catching that.  I have not been at computer...on vacation  At moment
pdvsaProject finance

Author

Commented:
Boag:  sorry for late response...getting caught up

It says I have a missing parenthesis or bracket: (i did put a parenthesis at very end but then said had wrong # arg's)
MyGroup: IIf(IsNull([tblLCAmendHistory].[DateAmendApprovedByBank]) Or (Not IsNull([tblLCAmendHistory].[WaitingBeneConsentYN]),"Awaiting Amend Approval by Bank","Recently Approved Amend by Bank")
MIS Liason
CERTIFIED EXPERT
Most Valuable Expert 2012
Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION
pdvsaProject finance

Author

Commented:
thank you for the help...enjoy the vacation!
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.