Results 1 to 5 of 5
  1. #1
    5 Star Lounger
    Join Date
    Jul 2001
    Location
    NJ, USA
    Posts
    617
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Running totals (AccessXP)

    How do you create a running total using queries? What is the best approach? The problem is dealing with partial payments on an invoice.
    For example person invoiced for $102 on 7/27 he then made two $25 payments on 8/6 and 8/27. I want to be able to show after 8/6 he owes $77 and after the 8/27 payment he owes $52.

    Thank you. Fay

  2. #2
    5 Star Lounger
    Join Date
    Jul 2001
    Location
    NJ, USA
    Posts
    617
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Running totals (AccessXP)

    Thanks Preston. Fay

  3. #3
    5 Star Lounger
    Join Date
    Jul 2001
    Location
    NJ, USA
    Posts
    617
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Running totals (AccessXP)

    Hi Preston. I checked it out. It isn't exactly what I want. The referenced article runs the total for the complete report not for just a specific invoice. I have fiddled with the query and haven't figured it out. Any other ideas? Fay

  4. #4
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    La Verne, California, USA
    Posts
    313
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Running totals (AccessXP)

    Check out this article in the MSKB: MSKB article 208714

  5. #5
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Running totals (AccessXP)

    Have you tried grouping the report by Invoice, and using a text box bound to the Payment field with the Running Sum property (in the Data tab of the Properties window) set to Group?

Posting Permissions

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