Unanswered: Count and IIf in Group Footer of report
What am I doing wrong?
I have a query that has calculated the difference between a due date and completed date and have named this field "Days Late." My report is grouped by whom the task was assigned to. In the group footer, I have counted the total tasks [BMR#] for each person. Now I am trying to calculate the number of tasks [BMR#] that were late. If "days late" is greater than 0, then the task was not completed on time. In the group footer I have created a text box and have the following formula in the control source, but I am missing something because it is not working (nothing is popluating the text field.)
My syntax is as follows: =IIf([Days Late]>0,Count([BMR#]))