Grouping and Report

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
pdvsaProject financeAsked:
Who is Participating?
 
Jeffrey CoachmanMIS LiasonCommented:
<I have not been at computer...on vacation  At moment >
LOL!
Me Too!
I'm in sunny Escondido Ca...

In any event, try this:

MyGroup: IIf(IsNull([tblLCAmendHistory].[DateAmendApprovedByBank]) Or (Not IsNull([tblLCAmendHistory].[WaitingBeneConsentYN])),"Awaiting Amend Approval by Bank","Recently Approved Amend by Bank")
0
 
pdvsaProject financeAuthor Commented:
oops the [WaitingBeneConsent] would need to have  a condition of true or Yes for the "Awaiting Amend Approval by Bank" part.
0
 
Jeffrey CoachmanMIS LiasonCommented:
The basic syntax is:

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

Sample Query is attached
Access-EE.mdb
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
pdvsaProject financeAuthor 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")
0
 
Jeffrey CoachmanMIS LiasonCommented:
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")
0
 
pdvsaProject financeAuthor Commented:
Ok Thank you sir...will test this.  Have been out of pocket and willbe nxt few days.. Catch up soon...
0
 
Jeffrey CoachmanMIS LiasonCommented:
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")
0
 
pdvsaProject financeAuthor Commented:
I see ... Thanks for catching that.  I have not been at computer...on vacation  At moment
0
 
pdvsaProject financeAuthor 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")
0
 
pdvsaProject financeAuthor Commented:
thank you for the help...enjoy the vacation!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.