Grand total

  • Thread starter stephendeloach via AccessMonster.com
  • Start date
S

stephendeloach via AccessMonster.com

I am trying to get a Grand total of my subtotals in my report.. How do I
Total all of the subtotals? I have them in the Report Footer, the only
problem is, they are formulas? I need to total
=Sum([Longhorn])
=Sum([Tiger])
=Sum([Wildcat])
=Sum([Spare])
=Sum([Miscellaneous])
to have a Grand Total Hours.

I also need to total...
=Sum([Cost Per Hr]*[Longhorn])
=Sum([Cost Per Hr]*[Tiger])
=Sum([Cost Per Hr]*[Wildcat])
=Sum([Cost Per Hr]*[Spare])
=Sum([Cost Per Hr]*[Miscellaneous])
to have a Grand Total Cost.
Thanks.
 
D

Duane Hookom

Usually the same control source used in a group footer will work in a report
footer to total the entire report. What are you trying to do that this would
not work?
 
S

stephendeloach via AccessMonster.com

Im trying to get a grand total of all the totals... Do you know the formula?
Thanks.

Duane said:
Usually the same control source used in a group footer will work in a report
footer to total the entire report. What are you trying to do that this would
not work?
I am trying to get a Grand total of my subtotals in my report.. How do I
Total all of the subtotals? I have them in the Report Footer, the only
[quoted text clipped - 14 lines]
to have a Grand Total Cost.
Thanks.
 
D

Duane Hookom

Use the same control source you used to get your subtotals. If this doesn't
work, then come back with why your situation is different.
--
Duane Hookom
Microsoft Access MVP


stephendeloach via AccessMonster.com said:
Im trying to get a grand total of all the totals... Do you know the formula?
Thanks.

Duane said:
Usually the same control source used in a group footer will work in a report
footer to total the entire report. What are you trying to do that this would
not work?
I am trying to get a Grand total of my subtotals in my report.. How do I
Total all of the subtotals? I have them in the Report Footer, the only
[quoted text clipped - 14 lines]
to have a Grand Total Cost.
Thanks.
 
S

stephendeloach via AccessMonster.com

This is what I tpyed in. =Sum([Longhorn]+[Tiger]+[Wildcat]+[Miscellaneous]+
[Spare]) the Text36: comes up but no numbers? Then for the Grand total of
dollars I put in.. =Sum([Cost Per Hr]*[Wildcat])+([Cost Per Hr]*[Tiger])+(
[Cost Per Hr]*[Longhorn])+([Cost Per Hr]*[Spare])+([Cost Per Hr]+
[Miscellaneous]) that dosent even look right! Did the same thing, Text38:
no numbers? Thanks.

Duane said:
Use the same control source you used to get your subtotals. If this doesn't
work, then come back with why your situation is different.
Im trying to get a grand total of all the totals... Do you know the formula?
Thanks.
[quoted text clipped - 8 lines]
 
D

Duane Hookom

Are all of your fields populated with numeric values? If not, you need to use
...Nz(WildCat,0) + Nz(Tiger,0)...
Did you enter this in the Report Footer section or the Page Footer section?

--
Duane Hookom
Microsoft Access MVP


stephendeloach via AccessMonster.com said:
This is what I tpyed in. =Sum([Longhorn]+[Tiger]+[Wildcat]+[Miscellaneous]+
[Spare]) the Text36: comes up but no numbers? Then for the Grand total of
dollars I put in.. =Sum([Cost Per Hr]*[Wildcat])+([Cost Per Hr]*[Tiger])+(
[Cost Per Hr]*[Longhorn])+([Cost Per Hr]*[Spare])+([Cost Per Hr]+
[Miscellaneous]) that dosent even look right! Did the same thing, Text38:
no numbers? Thanks.

Duane said:
Use the same control source you used to get your subtotals. If this doesn't
work, then come back with why your situation is different.
Im trying to get a grand total of all the totals... Do you know the formula?
Thanks.
[quoted text clipped - 8 lines]
to have a Grand Total Cost.
Thanks.
 
S

stephendeloach via AccessMonster.com

Yes all of my fields are numeric values. I entered it in the Report Footer..

Duane said:
Are all of your fields populated with numeric values? If not, you need to use
...Nz(WildCat,0) + Nz(Tiger,0)...
Did you enter this in the Report Footer section or the Page Footer section?
This is what I tpyed in. =Sum([Longhorn]+[Tiger]+[Wildcat]+[Miscellaneous]+
[Spare]) the Text36: comes up but no numbers? Then for the Grand total of
[quoted text clipped - 10 lines]
 
D

Duane Hookom

Create new report with the same record source and add one text box in the
report footer section with a control source of:
=Sum(Nz([Longhorn],0)+Nz([Tiger],0)+Nz([Wildcat],0)+Nz([Miscellaneous],0)+
Nz([Spare],0))

Are Longhorn, Tiger, Wildcat,... names of fields in your report's record
source?

BTW: do you understand this might not be a well normalized table structure?

--
Duane Hookom
Microsoft Access MVP


stephendeloach via AccessMonster.com said:
Yes all of my fields are numeric values. I entered it in the Report Footer..

Duane said:
Are all of your fields populated with numeric values? If not, you need to use
...Nz(WildCat,0) + Nz(Tiger,0)...
Did you enter this in the Report Footer section or the Page Footer section?
This is what I tpyed in. =Sum([Longhorn]+[Tiger]+[Wildcat]+[Miscellaneous]+
[Spare]) the Text36: comes up but no numbers? Then for the Grand total of
[quoted text clipped - 10 lines]
to have a Grand Total Cost.
Thanks.
 
S

stephendeloach via AccessMonster.com

Creating a new report would take me a while.. Is there a way I can save my
report as a template, so i will have the same layout? I entered what you said
to enter in the report footer of the report i have now and it gave me the
total numbers of hours! Were getting closer! Is this sum going to be updated
everytime something is added to the report? (new hours) Also, how would I get
the total number of Cost? Yes, Longhorn, Tiger, Wildcat, etc are names of
fields in my reports record source.... Is that good or bad? Just curious..
Why might this not be a well normalized table structure? Thanks for your time.


Duane said:
Create new report with the same record source and add one text box in the
report footer section with a control source of:
=Sum(Nz([Longhorn],0)+Nz([Tiger],0)+Nz([Wildcat],0)+Nz([Miscellaneous],0)+
Nz([Spare],0))

Are Longhorn, Tiger, Wildcat,... names of fields in your report's record
source?

BTW: do you understand this might not be a well normalized table structure?
Yes all of my fields are numeric values. I entered it in the Report Footer..
[quoted text clipped - 7 lines]
 
S

stephendeloach via AccessMonster.com

One more thing.. If I create a new report, where would I need to put the
subtotals if the Grand Totals are going in the report footer?

Duane said:
Create new report with the same record source and add one text box in the
report footer section with a control source of:
=Sum(Nz([Longhorn],0)+Nz([Tiger],0)+Nz([Wildcat],0)+Nz([Miscellaneous],0)+
Nz([Spare],0))

Are Longhorn, Tiger, Wildcat,... names of fields in your report's record
source?

BTW: do you understand this might not be a well normalized table structure?
Yes all of my fields are numeric values. I entered it in the Report Footer..
[quoted text clipped - 7 lines]
 
D

Duane Hookom

If you are getting the totals, then there should be no reason to create a new
report. The new report was to be used only to trouble shoot the issue you
were having. Apparently the issue of creating a grand total is resolved.

If you have field names that are actually data values, this suggests an
un-normalized structure. If you provided information on your table structure
and what you were storing in those fields, someone could offer some opinions.

--
Duane Hookom
Microsoft Access MVP


stephendeloach via AccessMonster.com said:
Creating a new report would take me a while.. Is there a way I can save my
report as a template, so i will have the same layout? I entered what you said
to enter in the report footer of the report i have now and it gave me the
total numbers of hours! Were getting closer! Is this sum going to be updated
everytime something is added to the report? (new hours) Also, how would I get
the total number of Cost? Yes, Longhorn, Tiger, Wildcat, etc are names of
fields in my reports record source.... Is that good or bad? Just curious..
Why might this not be a well normalized table structure? Thanks for your time.


Duane said:
Create new report with the same record source and add one text box in the
report footer section with a control source of:
=Sum(Nz([Longhorn],0)+Nz([Tiger],0)+Nz([Wildcat],0)+Nz([Miscellaneous],0)+
Nz([Spare],0))

Are Longhorn, Tiger, Wildcat,... names of fields in your report's record
source?

BTW: do you understand this might not be a well normalized table structure?
Yes all of my fields are numeric values. I entered it in the Report Footer..
[quoted text clipped - 7 lines]
to have a Grand Total Cost.
Thanks.
 
D

Duane Hookom

I should have also replied that the numbers in the report should always
reflect the current values in your tables.

How do you want to calculate "total number of Cost"?
--
Duane Hookom
Microsoft Access MVP


stephendeloach via AccessMonster.com said:
Creating a new report would take me a while.. Is there a way I can save my
report as a template, so i will have the same layout? I entered what you said
to enter in the report footer of the report i have now and it gave me the
total numbers of hours! Were getting closer! Is this sum going to be updated
everytime something is added to the report? (new hours) Also, how would I get
the total number of Cost? Yes, Longhorn, Tiger, Wildcat, etc are names of
fields in my reports record source.... Is that good or bad? Just curious..
Why might this not be a well normalized table structure? Thanks for your time.


Duane said:
Create new report with the same record source and add one text box in the
report footer section with a control source of:
=Sum(Nz([Longhorn],0)+Nz([Tiger],0)+Nz([Wildcat],0)+Nz([Miscellaneous],0)+
Nz([Spare],0))

Are Longhorn, Tiger, Wildcat,... names of fields in your report's record
source?

BTW: do you understand this might not be a well normalized table structure?
Yes all of my fields are numeric values. I entered it in the Report Footer..
[quoted text clipped - 7 lines]
to have a Grand Total Cost.
Thanks.
 
S

stephendeloach via AccessMonster.com

I have all of my subtotals in the Report Footer. All I need is to add all of
the subtotals together... But to me that is easier said than done.. The
control source of the text box I need to add is =Sum([Cost Per Hr]*
[Longhorn]) , =Sum([Cost Per Hr]*[Wildcat]) , =Sum([Cost Per Hr]*[Tiger])
, =Sum([Cost Per Hr]*[Spare]) and =Sum([Cost Per Hr]*[Miscellaneuos]) .
How would I do this? Thanks.

Duane said:
I should have also replied that the numbers in the report should always
reflect the current values in your tables.

How do you want to calculate "total number of Cost"?
Creating a new report would take me a while.. Is there a way I can save my
report as a template, so i will have the same layout? I entered what you said
[quoted text clipped - 20 lines]
 
D

Duane Hookom

How about a text box with a control source like:
=Sum([Cost Per Hr]*[Longhorn])+Sum([Cost Per Hr]*[Wildcat])+Sum([Cost Per
Hr]*[Tiger])+Sum([Cost Per Hr]*[Spare])+Sum([Cost Per Hr]*[Miscellaneuos])
or
=[Cost Per Hr]*Sum([Longhorn]+[Wildcat]+[Tiger]+[Spare]+[Miscellaneuos])

Again, if you potentially have Null values, you would need to use Nz().

--
Duane Hookom
Microsoft Access MVP


stephendeloach via AccessMonster.com said:
I have all of my subtotals in the Report Footer. All I need is to add all of
the subtotals together... But to me that is easier said than done.. The
control source of the text box I need to add is =Sum([Cost Per Hr]*
[Longhorn]) , =Sum([Cost Per Hr]*[Wildcat]) , =Sum([Cost Per Hr]*[Tiger])
, =Sum([Cost Per Hr]*[Spare]) and =Sum([Cost Per Hr]*[Miscellaneuos]) .
How would I do this? Thanks.

Duane said:
I should have also replied that the numbers in the report should always
reflect the current values in your tables.

How do you want to calculate "total number of Cost"?
Creating a new report would take me a while.. Is there a way I can save my
report as a template, so i will have the same layout? I entered what you said
[quoted text clipped - 20 lines]
to have a Grand Total Cost.
Thanks.
 
S

stephendeloach via AccessMonster.com

Thats it! Thank you very much.

Duane said:
How about a text box with a control source like:
=Sum([Cost Per Hr]*[Longhorn])+Sum([Cost Per Hr]*[Wildcat])+Sum([Cost Per
Hr]*[Tiger])+Sum([Cost Per Hr]*[Spare])+Sum([Cost Per Hr]*[Miscellaneuos])
or
=[Cost Per Hr]*Sum([Longhorn]+[Wildcat]+[Tiger]+[Spare]+[Miscellaneuos])

Again, if you potentially have Null values, you would need to use Nz().
I have all of my subtotals in the Report Footer. All I need is to add all of
the subtotals together... But to me that is easier said than done.. The
[quoted text clipped - 12 lines]
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top