sum of all numbers

  • Thread starter Thread starter DFDGirl
  • Start date Start date
D

DFDGirl

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:)
 
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:

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:)
Click to expand...
 
If there is a chance that some months might have null values, you need to
use
Nz([Dec],0)
rather than just
[Dec]
 
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])
 
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
 
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
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:
Click to expand...
[quoted text clipped - 16 lines]
I am sure it is a simple solution...please help:)
Click to expand...
Click to expand...
 
Back
Top