Results 1 to 4 of 4
  1. #1
    Lounger
    Join Date
    May 2001
    Location
    Engerland
    Posts
    34
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Access 97 - Decrement Balance Outstanding

    I am using an append query to post a payment history into a table of payments. I need to be able to show a balance outstanding total - in most cases I can achieve this easily by appending [invoice amount - payment amount] to the appropriate field.

    However, if there is more than one payment (e.g. part payments by different methods), the balance outstanding will only show the invoice amount minus the last payment processed (i.e. does not take into account the sum of the payments).

    I would normally use a recordset to calculate a running sum and append this instead, however the data source includes many different invoices so I can't do this.

    I'd really appreciate any help with this!

    TIA

    Ade

  2. #2
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    Tennessee
    Posts
    194
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Access 97 - Decrement Balance Outstanding

    in the totals part of your query set if for sum in both fields then subtract payment from invoice

  3. #3
    Lounger
    Join Date
    May 2001
    Location
    Engerland
    Posts
    34
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Access 97 - Decrement Balance Outstanding

    JerryC

    I'm not certain that this will work as I have multiple different invoices in the query source - would this not just sum all of them, rather than by invoice? Or have I misinterpreted?
    <img src=/S/confused.gif border=0 alt=confused width=15 height=20>

  4. #4
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    Tennessee
    Posts
    194
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Access 97 - Decrement Balance Outstanding

    you have to set the invoice criteria parameter for the invoice you are working on if you only want one invoice if not try grouping on the invoice field in the totals area of the query

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •