473,836 Members | 1,534 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Pass Running-sum Group Total from Sub Report to Main Report

Hi,

I've got an access report which contains a sub-report. The sub-report
contains various items in a group Footer which culminates in a running sum
text box called txtGrandTotal. I want to use this 'total' in the main
report so I have a text box with the following:-

=([Reports]![RPT_MainReport]![RPT_SubReport].[Report]![txtGrandTotal])

For some reason, which I'm sure is perfectly obvious but I'm buggered if I
can think why, the above doesn't actually show the grand total. Instead it
shows the value of the first record in the sub-report's group footer. I.e.

txtGrandTotal in RPT_SubReport shows the CORRECT value

[Reports]![RPT_MainReport]![RPT_SubReport].[Report]![txtGrandTotal] shows
the INCORRECT value
What am I missing?!?

TIA,

Andy
Nov 13 '05 #1
3 5157
A *running sum* text box in the subreport? Hmm. That's probably a timing
issue, i.e. at the time the main report reads the value from the subreport,
only the first record has been accessed.

Is there any chance of placing a text box in a group footer in the
subreport, and setting its ControlSource to:
=Sum([SomeField])
so that this box is dependent on all the others, and so Access can get the
total only after it is completed?

(You can set the Visible property of the text box or even the group footer
section to No if you don't want it shown.)

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Pecanfan" <pe******@no.sp am> wrote in message
news:11******** *******@smtp-1.griffin.com.. .

I've got an access report which contains a sub-report. The sub-report
contains various items in a group Footer which culminates in a running sum
text box called txtGrandTotal. I want to use this 'total' in the main
report so I have a text box with the following:-

=([Reports]![RPT_MainReport]![RPT_SubReport].[Report]![txtGrandTotal])

For some reason, which I'm sure is perfectly obvious but I'm buggered if I
can think why, the above doesn't actually show the grand total. Instead
it
shows the value of the first record in the sub-report's group footer.
I.e.

txtGrandTotal in RPT_SubReport shows the CORRECT value

[Reports]![RPT_MainReport]![RPT_SubReport].[Report]![txtGrandTotal] shows
the INCORRECT value
What am I missing?!?

TIA,

Andy

Nov 13 '05 #2
> Is there any chance of placing a text box in a group footer in the
subreport, and setting its ControlSource to:
=Sum([SomeField])
so that this box is dependent on all the others, and so Access can get the
total only after it is completed?


Do you mean create *any* Sum field in the group footer - i.e.
=Sum([Anything]) ? If so I've already got a summing field in the group
footer (the whole shebang is in the group footer) - I don't have anything in
the Detail of the subreport at all - is that bad?

Cheers,

Andy
Nov 13 '05 #3
> > Is there any chance of placing a text box in a group footer in the
subreport, and setting its ControlSource to:
=Sum([SomeField])
so that this box is dependent on all the others, and so Access can get the total only after it is completed?
Do you mean create *any* Sum field in the group footer - i.e.
=Sum([Anything]) ? If so I've already got a summing field in the group
footer (the whole shebang is in the group footer) - I don't have anything

in the Detail of the subreport at all - is that bad?


Oh, Access... how I love it. Gave up and created another utterly pointless
subreport and copied all the 'summary' stuff I wanted in the main report
into this sub report - then inserted this subreport back into the main
report. That works!

Gah! :-)

Andy
Nov 13 '05 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
2591
by: Jos Yule | last post by:
Hello all. I doing a project which uses Macromedia's Flash program and Python. This is a 'because i want to see if i can do it' kind of thing, so i know that there will be better/easier ways to accomplish what i'm about to lay out! I am going to use a flash app as a kind of chat app, but because Flash does not accept incoming socket connections, i'd like to use a small Python server to act as the socket proxy (i think that's the right...
9
2556
by: timothy.williams | last post by:
Hi. I trying to write an extension module to call some C libraries so I can use them in Python. Several of the library functions pass pointers to structures as arguments. I was thinking that I could create a class for each structure, but I'm not sure how to get the data back and forth. The example the "Extending and Embedding the Python Interpreter" manual has examples of passing strings and ints using PyArg_ParseTupleAndKeywords(), but...
4
11592
by: Gerhard Pretorius | last post by:
ON Win 2003 IIS6, Since yesterday, (12 Aug 2003) for some strange reason, (after installing WindowsServer2003-KB823980-x86-ENU.exe) I cannot pass the Request object to to VB COM DLL. I have a funciton inVB DLL Function BuildSqlWhereFromHTML(ByRef AspReq As ASPTypeLibrary.Request, _ ByRef AspSes As ASPTypeLibrary.Session) As String
14
9069
by: jj | last post by:
Is it possible to call a remote php script from within Access? I'm thinking something like: DoCMD... http://www.domain.com/scripts/dataquery.php DoCmd.OpenQuery "update_data", acNormal, acEdit ..... So the PHP script does something on the server database, then when a linked table is viewed within access, the data changes have been made?
4
6546
by: MLH | last post by:
I apologize in advance to forum readers noticing this somewhat redundant post. I fear that my Subject Heading was ill-chosen in earlier post I made on this topic. Am hoping that a clearer Subject heading will attract the knowledgeable forum contributors I'm seeking. Thank-you... I'm being academically challenged trying to build a pass-through query inside of Access 2.0 to "reach out 'n touch" a remote data file running on a Linux box in...
1
1952
by: Peter Mullen | last post by:
Whew, it's been a while since I posted. Fogive me all for I have... anyway. I would like to be able to write a method of an object that could accept a string and set the corresponding form. It an easy thing to do if I am talking about a recordset. I could simply loop through the recordset collection, find the one that I wanted, and then set my object to the one that I found.
3
12614
by: ILCSP | last post by:
Hello, I'm fairly new to the concept of running action pass through queries (insert, update, etc.) from Access 2000. I have a SQL Server 2000 database and I'm using a Access 2K database as my front end. I'm using a blank pass through query which gets the Transact-SQL part inserted from a button in my form. After inserting the Transact-SQL code into the pass through query, I 'open the recordset' to make the query run. However,...
5
7829
by: David++ | last post by:
Hi folks, I would be interested to hear peoples views on whether or not 'pass by reference' is allowed when using a Web Service method. The thing that troubles me about pass-by-reference into a WebService is that essentially we are passing an address of an object which resides on the 'local machine' i.e. a local machine object address. Surely when the WebService method is called and run 'on the server', the reference type will be...
2
4311
by: pamela fluente | last post by:
I have an application running. A file type is registered with this application. When the user click on a file of such type a new instance of the application is loaded with command line (file name). I want to shut done this new instance an to notify the instance which is already running, by passing the command line to it (so that the file can be open by the application already runnning). Here is my code, how do I notify the running...
12
11121
by: raylopez99 | last post by:
Keywords: scope resolution, passing classes between parent and child forms, parameter constructor method, normal constructor, default constructor, forward reference, sharing classes between forms. Here is a newbie mistake that I found myself doing (as a newbie), and that even a master programmer, the guru of this forum, Jon Skeet, missed! (He knows this I'm sure, but just didn't think this was my problem; LOL, I am needling him) If...
0
9671
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
10551
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
0
10254
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
9379
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
0
6979
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
5650
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
5828
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
2
4021
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
3116
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.