Adding report totals with subreport totals

leezac
leezac used Ask the Experts™
on
I am using MSAccess2003. I am needing to add two fields  - one is on main report and the second is on a subreport.  Attached is a sample.  

I will be adding more rows to subreport - is there a way to do a running total then then a grand total at the end?

It has been a while since I have done this and obviously I have forgotten the sequence.


Thanks in advance.
db8.zip
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Brian PiercePhotographer
Awarded 2007
Top Expert 2008

Commented:
Nor sure exactly what you are trying to do but any calculation needs to go in the report footer/sub report footer - not in a page footer

Author

Commented:
I am needing to add Sales from main report to Rule 1 Sells on subreport.
MIS Liason
Most Valuable Expert 2012
Commented:
There is really no need for the complexity of a subreport AFAICT.
You can create a "Grouped Report" with he report wizard and subtotals can be added automatically.

"is there a way to do a running total then then a grand total at the end?"
Do you mean a "running total" after each record, or do you just want one subtotal?

Is this for one main record of many?

Your sample really does not contain enough info for a targeted solution...

In any event see the attached sample, it should get you started

;-)

JeffCoachman
Database16.mdb
Success in ‘20 With a Profitable Pricing Strategy

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden using our free interactive tool and use it to determine the right price for your IT services. Start calculating Now!

Author

Commented:
Awesome - great - I think will work so I do not have to do subreport.

Let me look at this evening and will post acceptance tomorrow.  Thank you!!!!

Author

Commented:
thank you!!!
Jeffrey CoachmanMIS Liason
Most Valuable Expert 2012

Commented:
;-)
...reporting basics really...

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial