Sum of two sums

Does anyone know how to get two sums to calculate and show on a report?
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/14038-sum-of-two-sums.html

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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=14038
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/For...ccess/200607/1

 
Do share your immediate thoughts or reactions on this issue? We value your views! Login Now! or Sign Up Today! to share your views with us.. Gurfateh!

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.
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=14038

--
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" wrote in message
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=14038
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

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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=14038
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.
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=14038
>
> 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/For...ccess/200607/1
>
>

Thank you
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=14038
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=14038

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/For...ccess/200607/1

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.)]
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=14038
>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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=14038
>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/For...ccess/200607/1