If Is Null and report
Posted on 2011-03-09
Experts, I have this grouping on my report:
MyGroup: IIf(IsNull([tblLCAmendHistory].[DateAmendApprovedByBank]),"Awaiting Amend Approval by Bank","Recently Approved Amend by Bank")
the Grouping divides records between Amendments that "have not been approved" and "have been approved" based on whether or not the [DateAmendApprovedByBank] Is Null or Is Not Null. If it [DateAmendApprovedByBank] is Null then it is "Awaiting Approval by Bank".
What I want to do is limit the records in the Group: "Recently Approved by Bank" as the list is pretty long. I would like a criteria to only show 1 month from current date based on [DateAmendApprovedByBank].
I thought I could drag down the [DateAmendApprovedByBank] and use a between formula (current date - 1 month) but that would remove any records that have not been approved and or course I need to show those records that have not been approved for >1month.
Any questions please let me know. (SQL will be posted below)