MS Access 2010 - Subreport

Good afternoon:

I have a report that contains a subreport.  I have passed the value from the subreport to the main report to use in the Report total.  My problem is - I can't Sum the field with the Shared/Passed variable.  

Formula on Main report to pull the data from the sub to the main:
=IIf([srpt_FTMC_MiscChrg].[Report].[HasData],Nz([srpt_FTMC_MiscChrg].[Report]![PriceExtendedAmount],0),0)
This resides in the GroupFooter1 section (SO OrderNumber Footer)

I need to total this field, a running total in the report footer to add to the Total Extended Margin.

When I attempt to add a field to Sum the information above into the Report Footer - when the report runs it prompts me for a value.  

I'm new to Access 2010.  

Any help is greatly appreciated.  

Thank you.
Erin LealeConsultant/ControllerAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

IrogSintaCommented:
What is the name of the Textbox that has this formula?  If for instance, the name is txtExtAmount, then you can add a Textbox to your report footer with the following:
=Sum([txtExtAmount])
Ron
Erin LealeConsultant/ControllerAuthor Commented:
Hi Ron:

I tried that.  I created a Textbox:  = Sum([txtMiscCharge]) - the text box is located in the Report Footer.  When the report runs, it prompts me for a value.  I'm not sure why it is doing that.  

Is it an evaluation time issue on that field?

Thanks.
IrogSintaCommented:
Would you be able to upload a copy of the db with just the report and subreport along with enough data in the table to view it?  Be sure to remove any private info first.

Ron
The 7 Worst Nightmares of a Sysadmin

Fear not! To defend your business’ IT systems we’re going to shine a light on the seven most sinister terrors that haunt sysadmins. That way you can be sure there’s nothing in your stack waiting to go bump in the night.

Gustav BrockCIOCommented:
Try the direct calculation:

=IIf([srpt_FTMC_MiscChrg].[Report].[HasData],Sum([srpt_FTMC_MiscChrg].[Report]![txtMiscCharge]),0)

/gustav
Erin LealeConsultant/ControllerAuthor Commented:
* Ron - The database is very large, this is only a portion of it.  If I can create a small example today I will upload.

* Gustav - I tried the example formula above, it doesn't prompt me but returns a 0 value, in the example I have it should return 325.00.  Is there a running total function that I can use?  What I have found and tried put the running total in the Group Footer - if I move the field to the Report footer - it returns a 0.

Thank you.
Erin LealeConsultant/ControllerAuthor Commented:
All - I got it to work.

On the [MiscChrg] field - Data Tab | Running Sum | I changed that to OverAll.  I left it in the Section with the subreport and turned the visible property to no.

In the Report Footer - I created a Text box, set the control source to =[MiscChrg] - I'm now able to use the total in the Report Total for the GM Dollars.

Thank you.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Erin LealeConsultant/ControllerAuthor Commented:
Thank you.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.