sum of all numbers

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

DFDGirl - 01 Dec 2005 16:13 GMT

I have a report that is grouped by account # and in the acct# footer it
looks like this with the exeption of sum of all:

jan feb mar ***through *** dec sum of
all
Acct # 1 150 300 250 25 1139
Acct # 2 50 30 25 55 401

and so on for about 50 accts...

my problem is I have each month doing a sum of for each account...
I even tried to query each month....

either =Sum([jan]) or =SumOf([jan])

but when I try to sum all 12 months...i do not get anything.

=Sum([jan]+[feb]+[mar]).....

I am sure it is a simple solution...please help:)

Reply to this Message

OfficeDev18 - 01 Dec 2005 16:23 GMT

In order to answer, I need two pieces of information: first of all, what are
the actual names of the text boxes in the footer, and what is their control
source property (in the report's property sheet)? Second, what is the name
and control source property of the sumofall text box?

HTH

>I have a report that is grouped by account # and in the acct# footer it
>looks like this with the exeption of sum of all:
[quoted text clipped - 16 lines]
>
>I am sure it is a simple solution...please help:)

Signature

Sam

Reply to this Message

DFDGirl - 01 Dec 2005 16:31 GMT

the names would be if I pulled from the table

jan feb mar in the control box would be =Sum ([jan]

if from the query

SumOfjan in the control box would be =Sum([SumOfjan])

Reply to this Message

Duane Hookom - 01 Dec 2005 16:25 GMT

If there is a chance that some months might have null values, you need to
use
Nz([Dec],0)
rather than just
[Dec]

Signature

Duane Hookom
MS Access MVP
--

>I have a report that is grouped by account # and in the acct# footer it
> looks like this with the exeption of sum of all:
[quoted text clipped - 16 lines]
>
> I am sure it is a simple solution...please help:)

Reply to this Message

DFDGirl - 01 Dec 2005 16:29 GMT

Thank you I didn't try that...

Reply to this Message

Katrina - 01 Dec 2005 16:36 GMT

You have to use the source of the field on the report.
If you get your total for Jan by setting the source of the field to
Sum([jan]), your total for Feb by setting source to Sum([feb]), etc... then
in your sumof source you would need to put: Sum([jan]) + Sum([feb]) + etc...

Kind of hard to explain this process...sorry

Hope this helps
Katrina

> I have a report that is grouped by account # and in the acct# footer it
> looks like this with the exeption of sum of all:
[quoted text clipped - 16 lines]
>
> I am sure it is a simple solution...please help:)

Reply to this Message

OfficeDev18 - 01 Dec 2005 20:24 GMT

To my understanding, you thus have 14 textboxes in the footer section; one
for the account info, 12 for the months, and 1 for total amount.

Your Jan textbox, keeping what Duane said in mind, should have as a Control
Source the formula =Sum(Nz([jan],0)). the other months will follow in
identical fashion. the "All" though, will be a bit different. The Control
Source will have to have the formula =Sum(Sum(Nz([jan],0)) + Sum(Nz([feb],0))
+ Sum(Nz([mar],0)) + Sum(Nz([apr],0)) + Sum(Nz([may],0)) + Sum(Nz([jun],0)) +
Sum(Nz([jul],0)) etc. etc. )

HTH

>You have to use the source of the field on the report.
>If you get your total for Jan by setting the source of the field to
[quoted text clipped - 10 lines]
>>
>> I am sure it is a simple solution...please help:)

Signature

Sam

Reply to this Message