Sum fields if values of another fill equals specific value?

Discussion in 'Access Reports' started by david.isaacks@mail.va.gov, Apr 21, 2006.

  1. Guest

    I have a report with three fields. [Facility] [Month] [Count]

    The month field either equals "February" or "March". I want to have a
    text box that sums the Count field only if the Month Field equals
    "February".

    Any ideas?

    Dave
     
    , Apr 21, 2006
    #1
    1. Advertisements

  2. NetworkTrade Guest

    base your report on a query

    and then in the criteria of the calc field you can do an Iif function based
    on the string value of the month field....
    --
    NTC


    "" wrote:

    > I have a report with three fields. [Facility] [Month] [Count]
    >
    > The month field either equals "February" or "March". I want to have a
    > text box that sums the Count field only if the Month Field equals
    > "February".
    >
    > Any ideas?
    >
    > Dave
    >
    >
     
    NetworkTrade, Apr 21, 2006
    #2
    1. Advertisements

  3. Guest

    Thanks, got it working!

    Dave
     
    , Apr 21, 2006
    #3
  4. Andy35

    Joined:
    Aug 24, 2014
    Messages:
    1
    Likes Received:
    0
    Could you be more specific, please

    base your report on a query
    and then in the criteria of the calc field you can do an Iif function based
    on the string value of the month field....
     
    Andy35, Aug 24, 2014
    #4
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Deb Struble
    Replies:
    1
    Views:
    73
    Duane Hookom
    Dec 5, 2003
  2. Marge Barest via AccessMonster.com

    Report Sum adding values from 4 different fields

    Marge Barest via AccessMonster.com, Mar 23, 2005, in forum: Access Reports
    Replies:
    1
    Views:
    80
    Ken Hudson
    Mar 23, 2005
  3. schenell
    Replies:
    3
    Views:
    83
    Duane Hookom
    Aug 24, 2005
  4. Brandon

    Running Sum for Specific Values

    Brandon, Sep 2, 2005, in forum: Access Reports
    Replies:
    3
    Views:
    63
    Duane Hookom
    Sep 7, 2005
  5. James O

    Sum of another sum

    James O, Feb 21, 2006, in forum: Access Reports
    Replies:
    2
    Views:
    96
    James O
    Feb 21, 2006
  6. Replies:
    1
    Views:
    127
    Duane Hookom
    Jun 16, 2006
  7. Replies:
    5
    Views:
    96
    Duane Hookom
    Jul 17, 2006
  8. tepeh789
    Replies:
    1
    Views:
    84
    Allen Browne
    Jul 16, 2008
Loading...