Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2007

    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#]))

    Any suggestions?

    Thanks in advance for your help!

  2. #2
    Join Date
    May 2005
    Nevada, USA
    Provided Answers: 6

    =Sum(IIf([Days Late]>0,1,0))

  3. #3
    Join Date
    Apr 2007
    Thank you! That worked beautifully!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts