Getting Grand totals adding two sub reports totals

[PJShows]

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.

 

[Darrylles]

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."

 

[PJShows]

Thanks for the suggestion but that didn't work. i'm afraid I need to have some type of relationship.