Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Getting Grand totals adding two sub reports totals

Status
Not open for further replies.

PJShows

Programmer
Nov 1, 2002
7
US
I have two sub-reports.

sub-report1 with 4 colums AmountDue, Discount, Interest and Total. On these colums I'm getting group totals and over all totals.

I have the same colums on sub-report2.

I need to grab the over all totals from both sub-reports and add them together. They look like this is the source control, however "AmountDue" source control =

=Sum([Amount]+[Amount2]-[Amount3])

Thank for the help
PJ

They are not just grand total the are grand calculated totals.

I have try referencing a unbound text box back to the sub-reports and adding the totals. With no luck.

=ns([Reports]![Sub_rpt1]![Text47])+nz([Reports]![Sub_rpt2]![Text47])


It just shows #name on the report.
 
Hiya PJ,

Try this....

=ns([Reports]![Sub_rpt1]!REPORT![Text47])+nz([Reports]![Sub_rpt2]!REPORT![Text47])

(Noting REPORT in caps).

If this doesn't work, then it's simply syntax but still using 'REPORT' - see Access help on sub-forms, sub-report reference.

Regards,

Darrylle

"Never argue with an idiot, he'll bring you down to his level - then beat you with experience."
 
Thanks for the suggestion but that didn't work. i'm afraid I need to have some type of relationship.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top