Experts, I have a report and I need to add a “My Group” to this report in the query developer.
If [DateSentToBank] is not null and [DateOfIssueSB] is null then “Pending”
If [DateOfIssueSB] is NOT null then “Issued”
So, if at anytime, [DateOfIssueSB] is not null then its "Issued" but if [DateOfIssueSB] is null and [DateSentToBank] is not null then "Pending"
The below is not correct but It would look something like this:
MyGroup: IIf(Nz([DateSentToBank],"") and notisnull([DateOfIssueSB]) "Issued","Pending"))
I dont think I can use notisnull like I am doing.
I might be going about it the wrong way, open to any new suggestions how to do this.