Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2008
    Posts
    2

    Unanswered: Counting within Group in Report

    I designed a report from a table and grouped it by inventory account. I am trying to count on a field where "absent" is present. I have tried in the Group Footer, =DCount("[Item Number]","[InvQry]","[Status]='Absent'") and also =Count([Status]='Absent') in the text field and in both cases I get the total Absent for the whole report. I just want the group total at the end of each group.

    Thanks,
    Twiggymoo

  2. #2
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    Code:
    =SUM(Iif([Status]='Absent', 1))

  3. #3
    Join Date
    Feb 2008
    Posts
    2
    Thank you pootle flump!! It worked. I didn't know about that construct

Posting Permissions

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