Totals 1

[mimivdg2002]

I have two sub reports in my main report. Each subreport displays a number field. I would like to total these numbers for each row and also sum up the grand total for each column on the last page of the report. How can I do that? How can I access fields on my subreport from the main report?

 

[HitechUser]

mimivdg2002,

Maybe this way...

I believe you have to add a reference to your main report. Something like this:

=[Reports]![YourMainReport]![orders_invoiced]![txtUser]+(Sum([order_cost))

or this...

http://support.microsoft.com/?kbid=208998

..

 

[CaptainBob007]

That's a very handy article. (I figure I'll latch onto this thread since my question is almost identical).

I have a report with a subreport. I am totaling the subreport for each item in the report and bringing it to the main report without incident. Now at the bottom of the report, I am trying to calculate a grand total (of the totals of the subreports) and cant seem to get that to work. Any ideas?

 

[dhookom]

Create another copy of the control that "brings" the item to the main report. Name this control "txtTotFromSub". Set its running sum to Over All. Add a text box to the report footer with a control source of:
=txtTotFromSub

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]