467,877 Members | 1,199 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 467,877 developers. It's quick & easy.

Adding Subreport Subtotals on the main form

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:

Expand|Select|Wrap|Line Numbers
  1. =[Reports]![rptInvoice]![tblToursOffered subreport].[Report].[Text12]
Expand|Select|Wrap|Line Numbers
  1. =[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
Apr 14 '07 #1
  • viewed: 2139
Share:
8 Replies
MMcCarthy
Expert Mod 8TB
Try this ...

Expand|Select|Wrap|Line Numbers
  1. =[Reports]![rptInvoice]![tblToursOffered subreport].[Report].[Text12] + [Reports]![rptInvoice]![tblAdditionalCosts subreport].[Report].[Text14]
  2.  
Mary
Apr 16 '07 #2
NeoPa
Expert Mod 16PB
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).
Apr 18 '07 #3
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
Apr 18 '07 #4
NeoPa
Expert Mod 16PB
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 :)
Apr 18 '07 #5
MMcCarthy
Expert Mod 8TB
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
Apr 18 '07 #6
NeoPa
Expert Mod 16PB
Surely not the first Mary. You've certainly been right before now :D
Apr 19 '07 #7
Haha,

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

Thanks for all your help guys

Edd
Apr 19 '07 #8
MMcCarthy
Expert Mod 8TB
Haha,

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

Thanks for all your help guys

Edd
You're welcome.
Apr 19 '07 #9

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

9 posts views Thread by Downstreamer | last post: by
1 post views Thread by Kirsty Ryder | last post: by
1 post views Thread by shaqattack1992-newsgroups | last post: by
17 posts views Thread by =?Utf-8?B?SGVyYg==?= | last post: by
reply views Thread by jack112 | last post: by
reply views Thread by MrMoon | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.