Welcome to SPN

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

Sign Up Now!

Sum of two sums

Discussion in 'Information Technology' started by Jen B. via AccessMonster.com, Jul 28, 2006.

Tags:
  1. Jen B. via AccessMonster.com

    Guest

    Does anyone know how to get two sums to calculate and show on a report?

    Example: I have two columns in my report: Sum of 1st Mtg. and Sum of 2nd Mtg.

    I want the combined total of these two columns underneath. What is the
    equation?

    Also at the end of the report I want to do the same thing.

    Example: At the end of the two columns I have: =Sum[(Sum of 1st Mtg.)] and
    =Sum[(Sum of 2nd Mtg.)]

    I want my report to show the combined grand total of 1st and 2nd mtgs.
    underneath that.

    If anyone has any ideas on how this is done. I'd sure appreciate it. I
    cannot figure out the correct equations.

    Thank you

    --
    Message posted via AccessMonster.com
    http://www.accessmonster.com/Uwe/Forums.aspx/access/200607/1
     
  2. Loading...

    Similar Threads Forum Date
    Sikh News In Pictures: Hundreds Of Youngsters Attend Sikh Summer Camp - Slough Express Breaking News Aug 13, 2016
    Sikh News Sikhs On 'The Daily Show' Have Perfect Response For People Who Assume They're Muslim Breaking News Apr 27, 2016
    Opinion "Sikh monument" irks Kenyan Kisumu preachers (UPDATED) Breaking News Feb 8, 2014
    SALDEF Be an Intern in Washington This Summer (SALDEF) Sikh Organisations Dec 18, 2013
    1984 Sikh riots: US court issues summons to Sonia History of Sikhism Sep 6, 2013

  3. Allen Browne

    Allen Browne
    Expand Collapse
    Guest

    Just set the Control Source or the 3rd box to:
    =[Text100] + [Text101]
    or whatever those other text boxes are called.

    You might want to specify that if one of the boxes is null, Access should
    treat it as a zero:
    =Nz([Text100],0) + Nz([Text101],0)

    Also, set the Format property of all 3 text boxes to Currency (or perhaps
    General Number) so Access knows they are numeric values.

    --
    Allen Browne - Microsoft MVP. Perth, Western Australia.
    Tips for Access users - http://allenbrowne.com/tips.html
    Reply to group, rather than allenbrowne at mvps dot org.

    "Jen B. via AccessMonster.com" <u24559@uwe> wrote in message
    news:63dfd5e22dee7@uwe...
    > Does anyone know how to get two sums to calculate and show on a report?
    >
    > Example: I have two columns in my report: Sum of 1st Mtg. and Sum of 2nd
    > Mtg.
    >
    > I want the combined total of these two columns underneath. What is the
    > equation?
    >
    > Also at the end of the report I want to do the same thing.
    >
    > Example: At the end of the two columns I have: =Sum[(Sum of 1st Mtg.)]
    > and
    > =Sum[(Sum of 2nd Mtg.)]
    >
    > I want my report to show the combined grand total of 1st and 2nd mtgs.
    > underneath that.
    >
    > If anyone has any ideas on how this is done. I'd sure appreciate it. I
    > cannot figure out the correct equations.
    >
    > Thank you
     
  4. jmonty

    jmonty
    Expand Collapse
    Guest

    Each text box (control) that contains a formula on your report is assigned a
    name.
    For example purposes...it may be named Text1 and the other Text2.
    Text1 would have the formula: =Sum[(Sum of 1st Mtg.)]
    Text2 would have the formula: =Sum[(Sum of 2nd Mtg.)]
    Just create a new textbox (Text3) and enter the formula: =[Text1] + [Text2]

    To find the actual name of each of the two fields, open the report in design
    mode.
    Right-click on each textbox and select Properties. Click on the ALL tab.
    Scroll down to the Name field. It will probably say something like Text1 or
    Text45 or Text120, etc. etc. Just replace the correct names in the
    instructions above.

    jmonty


    "Jen B. via AccessMonster.com" wrote:

    > Does anyone know how to get two sums to calculate and show on a report?
    >
    > Example: I have two columns in my report: Sum of 1st Mtg. and Sum of 2nd Mtg.
    >
    > I want the combined total of these two columns underneath. What is the
    > equation?
    >
    > Also at the end of the report I want to do the same thing.
    >
    > Example: At the end of the two columns I have: =Sum[(Sum of 1st Mtg.)] and
    > =Sum[(Sum of 2nd Mtg.)]
    >
    > I want my report to show the combined grand total of 1st and 2nd mtgs.
    > underneath that.
    >
    > If anyone has any ideas on how this is done. I'd sure appreciate it. I
    > cannot figure out the correct equations.
    >
    > Thank you
    >
    > --
    > Message posted via AccessMonster.com
    > http://www.accessmonster.com/Uwe/Forums.aspx/access/200607/1
    >
    >
     
  5. Jen B. via AccessMonster.com

    Guest

    Thank you

    Allen Browne wrote:
    >Just set the Control Source or the 3rd box to:
    > =[Text100] + [Text101]
    >or whatever those other text boxes are called.
    >
    >You might want to specify that if one of the boxes is null, Access should
    >treat it as a zero:
    > =Nz([Text100],0) + Nz([Text101],0)
    >
    >Also, set the Format property of all 3 text boxes to Currency (or perhaps
    >General Number) so Access knows they are numeric values.
    >
    >> Does anyone know how to get two sums to calculate and show on a report?
    >>

    >[quoted text clipped - 17 lines]
    >>
    >> Thank you


    --
    Message posted via AccessMonster.com
    http://www.accessmonster.com/Uwe/Forums.aspx/access/200607/1
     
  6. Jen B. via AccessMonster.com

    Guest

    Thank you

    jmonty wrote:
    >Each text box (control) that contains a formula on your report is assigned a
    >name.
    >For example purposes...it may be named Text1 and the other Text2.
    >Text1 would have the formula: =Sum[(Sum of 1st Mtg.)]
    >Text2 would have the formula: =Sum[(Sum of 2nd Mtg.)]
    >Just create a new textbox (Text3) and enter the formula: =[Text1] + [Text2]
    >
    >To find the actual name of each of the two fields, open the report in design
    >mode.
    >Right-click on each textbox and select Properties. Click on the ALL tab.
    >Scroll down to the Name field. It will probably say something like Text1 or
    >Text45 or Text120, etc. etc. Just replace the correct names in the
    >instructions above.
    >
    >jmonty
    >
    >> Does anyone know how to get two sums to calculate and show on a report?
    >>

    >[quoted text clipped - 15 lines]
    >>
    >> Thank you


    --
    Message posted via AccessMonster.com
    http://www.accessmonster.com/Uwe/Forums.aspx/access/200607/1
     

Share This Page