Adding Subreport Subtotals on the main form

[xian2]

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:

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

=[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

[MMcCarthy]

Try this ...

=[Reports]![rptInvoice]![tblToursOffered subreport].[Report].[Text12] + [Reports]![rptInvoice]![tblAdditionalCosts subreport].[Report].[Text14]
 

Mary

[NeoPa]

Please visit this thread to see why we would rather you didn't double-post (Please do Not Double Post ).
This question has been asked and answered in another of your threads. Please understand that this wastes our time and reduces our ability to answer other members' threads (Problem Totalling Subreport on Main form).

[xian2]

Hi,

Sorry I wasnt intending to double post, I started the second post because I was technically asking a second question in the first post so thought it better to start it in a new post for anyone searching in the future.

Sorry, it wont happen again, and thanks for all your great help on all my questions NeoPa and Mary especially.

Edd

[NeoPa]

You're cool Edd.
It's ok to do as you did, but you need to explain that you're doing it with a link. That way it's all clear.
Glad you're happy with the answers anyway :)

[MMcCarthy]

You're cool Edd.
It's ok to do as you did, but you need to explain that you're doing it with a link. That way it's all clear.
Glad you're happy with the answers anyway :)

And we both gave the same answer. That must be a first. :D

[NeoPa]

Surely not the first Mary. You've certainly been right before now :D

[xian2]

Haha,

Are there no rules regarding personal banter within posts containing serious questions :-)

Thanks for all your help guys

Edd

[MMcCarthy]

Haha,

Are there no rules regarding personal banter within posts containing serious questions :-)

Thanks for all your help guys

Edd

You're welcome.