Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2004
    Location
    Seattle, WA
    Posts
    601

    Unanswered: Summarizing results

    I am making a report for my boss. He has name and a few other fields. Then he has about six binary fields (don't ask why he just didn't make them yes/no), then he has me make a different report on each of the binaries, showing selected fields. I did all that, but he would like to set up a counter. So when you draw up report A, it says there is X number of people in A.

    I tried =count([field]) and no luck. Any help?

  2. #2
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Provided Answers: 1
    =sum(iif(yourfield = WhateverYourTrueValueIs, 1, 0))

    ??
    oh yeah... documentation... I have heard of that.

    *** What Do You Want In The MS Access Forum? ***

  3. #3
    Join Date
    Jun 2004
    Location
    Seattle, WA
    Posts
    601
    I'll try that, I am doing a report if it is a 1. But I am not that column. So can I still do =sum(iif(a = 1, 1, 0))
    I assume I'd make this in the expression creator.

    [EDIT]
    It worked. Thanks!!
    Last edited by rguy84; 06-30-04 at 19:54.

Posting Permissions

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