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....
     
    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

Ask a Question

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

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.