Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2001
    Posts
    175

    Unanswered: Urgent report help needed

    On a report I have the following records displayed:

    amount inv.#
    $100.00 001
    $200.00 002
    $ 50.00 003
    ($150.00) 004
    ----------
    $200.00

    How can I match up the debits and credits. In other words, I only want to see inv. #002 - $200.00 on the report. Inv. #001 and 003 should be matched up to inv.#004

    Any help would be appreciated.

  2. #2
    Join Date
    Sep 2003
    Location
    The extremely Royal borough of Kensington, London
    Posts
    778
    Consider the following data:

    id1 100
    id2 25
    id3 25
    id4 50
    id5 (200)
    id6 75
    id7 100

    id5(200) =
    id1+id7
    id1+id2+id3+id4
    id1+id2+id6
    ...

    Given the above data, what output would you require?
    Bessie Braddock: Winston, you are drunk!
    Churchill: And Madam, you are ugly. And tomorrow, I'll be sober, and you will still be ugly.

  3. #3
    Join Date
    Sep 2001
    Posts
    175
    id5(200) =
    id1+id7
    id1+id2+id3+id4
    id1+id2+id6


    It doesn't matter which one as long as they total the credit (200) amount.

Posting Permissions

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