Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Reports / Printing / October 2004

Tip: Looking for answers? Try searching our database.

Somecallmejosh

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Running Sum - 25 Oct 2004 19:41 GMT
Hello,

I have set up a report that shows delinquent payments.  
In the report I have information grouped under client
name, then all items purhcased to which they are
delinquent on payment...

ex.

[Client][Item][Payment1][Payment2][CostOfItem][Balance]
Jane Doe
        "x"    $25.00               $50.00      $25.00
        "y"    $30.00               $80.00      $50.00
John Doe
         etc.

I am doing a running sum, in an unbound text box, in the
detail section to add the total balance per client.  I
would like to only see the balance at the end of each
group as opposed to seing it after every instance.  
Here's what I'm seeing in the report...

[Client][Item][Payment1][Payment2][CostOfItem][Balance]
Jane Doe
        "x"    $25.00               $50.00      $25.00
                               Total Balance $25.00  
        "y"    $30.00               $80.00      $50.00
                               Total Balance $75.00

Here's what I'd like to see:
[Client][Item][Payment1][Payment2][CostOfItem][Balance]
Jane Doe
        "x"    $25.00               $50.00      $25.00
        "y"    $30.00               $80.00      $50.00
                               Total Balance $75.00

Any suggestions on how to set this up so I only see 1
Total balance per client?  Thanks in advance.
Steve Schapel - 25 Oct 2004 20:21 GMT
Josh,

In the design view of your report, go to the Sorting and Grouping
dialog, and put a Group Footer for the Client.  Then, in the Client
Footer section thus created on the report, put an unbound textbox, with
its Control Source set to...
 =Sum([CostOfItem]-[Payment])
... or whatever your formula is (I couldn't understand the figures in
your example, so please adjust accordingly).

Signature

Steve Schapel, Microsoft Access MVP

> Hello,
>
[quoted text clipped - 34 lines]
> Any suggestions on how to set this up so I only see 1
> Total balance per client?  Thanks in advance.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.