Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

IIF statement combine

Posted on 2011-03-03
2
Medium Priority
?
486 Views
Last Modified: 2012-05-11
Experts,

I have the following in the reports qry design window divided between 2 groups.   Is it possible to combine the two statements into just one "MyGroup".  I would have in effect, 4 options based on either [DateApproved] or [DateAmendApprovedbyBank].  Or maybe a sub report would be better but I think it migght slow down the report speed.

thank you

MyGroup2: IIf(IsNull([tblLCAmendHistory].[DateApproved]),"Awaiting Amend Approval by Co","Amend Approved by Co")

MyGroup: IIf(IsNull([tblLCAmendHistory].[DateAmendApprovedByBank]),"Awaiting Amend Approval by Bank","Recently Approved Amend by Bank")
0
Comment
Question by:pdvsa
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 40

Accepted Solution

by:
als315 earned 2000 total points
ID: 35033946
You can combine it, but there will be little bit different cases:
1. [DateApproved] is null
1a. [DateApproved] is null and [DateAmendApprovedByBank] is null
1b. [DateApproved] is null and [DateAmendApprovedByBank] is not null
2. [DateApproved] is not null
2a. [DateApproved] is not null and [DateAmendApprovedByBank] is null
2b. [DateApproved] is not null and [DateAmendApprovedByBank] is not null
You should describe options for these cases
0
 

Author Closing Comment

by:pdvsa
ID: 35035310
Ok thank you.  I think i will need a sub report because i think it is too difficult to put all in one iif stmnt.

Thank you
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

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

As tax season makes its return, so does the increase in cyber crime and tax refund phishing that comes with it
Traditionally, the method to display pictures in Access forms and reports is to first download them from URLs to a folder, record the path in a table and then let the form or report pull the pictures from that folder. But why not let Windows retr…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…

704 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