Adding Subreport Subtotals on the main form

[Edddy]

Hi,

I have two subreports on my report and they both have a subtotal in the subreport footer section.

I have managed to work out how to call the subtotals in to the main form:

Code:

=[Reports]![rptInvoice]![tblToursOffered subreport].[Report].[Text12]



Code:

=[Reports]![rptInvoice]![tblAdditionalCosts subreport].[Report].[Text14]



But I have no idea how I add them now.

i have tried a simple Sum function but with no luck.

Any help much appreciated.

Many thanks in advance

Edd

 

[dhookom]

Try
=[tblToursOffered subreport].[Report].[Text12] + [tblAdditionalCosts subreport].[Report].[Text14]

You should also find and consistently use a naming convention.

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]

 

[Edddy]

Excellent.

Worked a treat. Thank you so much, you are a life saver.

As for standard names, originally they were named Subtotal1 and Subtotal2 but after moving them between different sections of the report and cutting and pasting etc, they seemed to revert back to the default names.

Thank you again

Best
Edd