Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Grouping and Report

Posted on 2011-04-19
10
Medium Priority
?
260 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
0
Comment
Question by:pdvsa
  • 6
  • 4
10 Comments
 

Author Comment

by:pdvsa
ID: 35425980
oops the [WaitingBeneConsent] would need to have  a condition of true or Yes for the "Awaiting Amend Approval by Bank" part.
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 35426874
The basic syntax is:

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

Sample Query is attached
Access-EE.mdb
0
 

Author Comment

by:pdvsa
ID: 35428206
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
 [eBook] Windows Nano Server

Download this FREE eBook and learn all you need to get started with Windows Nano Server, including deployment options, remote management
and troubleshooting tips and tricks

 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 35428462
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
 

Author Comment

by:pdvsa
ID: 35438634
Ok Thank you sir...will test this.  Have been out of pocket and willbe nxt few days.. Catch up soon...
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 35445513
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
 

Author Comment

by:pdvsa
ID: 35451236
I see ... Thanks for catching that.  I have not been at computer...on vacation  At moment
0
 

Author Comment

by:pdvsa
ID: 35494177
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
 
LVL 74

Accepted Solution

by:
Jeffrey Coachman earned 2000 total points
ID: 35495737
<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
 

Author Closing Comment

by:pdvsa
ID: 35501513
thank you for the help...enjoy the vacation!
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Microsoft Access is a place to store data within tables and represent this stored data using multiple database objects such as in form of macros, forms, reports, etc. After a MS Access database is created there is need to improve the performance and…
Windows Explorer lets you open cabinet (cab) files like any other folder. In VBA you can easily handle normal files and folders, but opening and indeed creating cabinet files takes a lot more - and that's you'll find here.
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …

579 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question