Query Result to Report

[Bob]

I have a query that gives the running total to a Client. How can I get this
total to show on my Already made Report.
The Client has his ID number linked to the query and report
Why I want to do this is if the report on his totals is say 3 pages long it
will show the grand total at the bottom instead of just adding up what is on
that page as it already does, but I can change that title to Sub Total and
then have this new total at the bottom
=qPayableTotalForPayment!Payable
Thanks for any help with this query total......Bob

 

[Guest]

Hi Bob,

I have a query that gives the running total to a Client. How can I get this
total to show on my Already made Report.

Are you sure that you really need a separate query? I may be wrong, but it
seems like you are making this more difficult than it needs to be. Try
placing a text box in the report's footer section with the following Control
Source:

=Sum([FieldName])

where FieldName is the name of a field with numeric data that you wish to
sum. Make sure to name the text box different from the FieldName, to prevent
a circular reference error.


Tom Wickerath
Microsoft Access MVP
https://mvp.support.microsoft.com/profile/Tom
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________

 

[Bob]

I have a query that gives the running total to a Client. How can I get
this total to show on my Already made Report.
The Client has his ID number linked to the query and report
Why I want to do this is if the report on his totals is say 3 pages long
it will show the grand total at the bottom instead of just adding up what
is on that page as it already does, but I can change that title to Sub
Total and then have this new total at the bottom
=qPayableTotalForPayment!Payable
Thanks for any help with this query total......Bob

I have manage to write this and it seems to work in my text box on my
report, Anything look wrong with this
=(NZ(DLookUp("Payable","qPayableTotalForPayment","OwnerID =" &
tbOwnerID.Value),""))
Thanks for any help...Bob