G
Guest
I'm trying to count how many Cases per month per Reviewer.
My Query has a value called months:
Months: IIf([IssueCloseDate] Is
Null,Null,MonthName(Month([IssueCloseDate]),True))
In my report I want to show a count ie: Jan=2, Feb=19, Mar=7.....
I Sorted/Grouped the report by Reviewer.
I'm trying to put one text box for Jan, another for Feb, etc...
This code is not giving me a total - what am I doing wrong??????
=Sum(IIf([Months]=Jan))
or
=Sum(IIf([Months])="Jan"))
Thanks
My Query has a value called months:
Months: IIf([IssueCloseDate] Is
Null,Null,MonthName(Month([IssueCloseDate]),True))
In my report I want to show a count ie: Jan=2, Feb=19, Mar=7.....
I Sorted/Grouped the report by Reviewer.
I'm trying to put one text box for Jan, another for Feb, etc...
This code is not giving me a total - what am I doing wrong??????
=Sum(IIf([Months]=Jan))
or
=Sum(IIf([Months])="Jan"))
Thanks