Avatar of leezac
leezac
 asked on

Adding report totals with subreport totals

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
Microsoft Access

Avatar of undefined
Last Comment
Jeffrey Coachman

8/22/2022 - Mon
Brian Pierce

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
leezac

ASKER
I am needing to add Sales from main report to Rule 1 Sells on subreport.
ASKER CERTIFIED SOLUTION
Jeffrey Coachman

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
leezac

ASKER
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!!!!
Your help has saved me hundreds of hours of internet surfing.
fblack61
leezac

ASKER
thank you!!!
Jeffrey Coachman

;-)
...reporting basics really...