Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

SUMIF In Report

Discussion in 'Information Technology' started by LanceMSU, Jul 28, 2006.

Tags:
  1. LanceMSU

    LanceMSU
    Expand Collapse
    Guest

    Can you do a sum if in a Access Report? If so can someone give me an example
    of how do do one. Basically I have three columns in a report that can so the
    value "Yes", "No" and "N/A". In a fourth column I have a numeric value. In
    the report I want to show the sum of the yes's, no's and N/A's.

    Thank you
     
  2. Loading...

    Similar Threads Forum Date
    UK British Sikh Report-2016 Breaking News Mar 24, 2016
    1984 The Story I Did Not Report In ’84 History of Sikhism Jun 28, 2015
    Opinion Top Green Beret Officer Forced to Resign Over Affair With WaPo Reporter Breaking News Jun 26, 2014
    United Sikhs New Report Shows Increasing Hate Attacks on Sikhs Sikh Organisations May 21, 2014
    Legal ACLU reports: Judge orders Sikh man, "Remove that rag, or Go to Jail! Breaking News Sep 27, 2013

  3. strive4peace

    strive4peace
    Expand Collapse
    Guest

    Hi Lance,

    here is an example for the first one:

    Name --> SumYes
    ControlSource --> =SUM(IIF(nz(Column1_controlname) = "Yes",
    column4_controlname, 0))


    Warm Regards,
    Crystal
    MVP Microsoft Access

    remote programming and training
    strive4peace2006 at yahoo.com
    *
    Have an awesome day ;)


    LanceMSU wrote:
    > Can you do a sum if in a Access Report? If so can someone give me an example
    > of how do do one. Basically I have three columns in a report that can so the
    > value "Yes", "No" and "N/A". In a fourth column I have a numeric value. In
    > the report I want to show the sum of the yes's, no's and N/A's.
    >
    > Thank you
     

Share This Page