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 3 5149
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
> 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
> > 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 This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
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...
|
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...
|
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
|
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?
|
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...
| |
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.
|
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,...
|
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...
|
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...
|
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...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
| |
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
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...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
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...
|
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();...
|
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...
| |
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
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...
| |