+ Reply to Thread
Results 1 to 4 of 4

Thread: Trying to grab varying lines of info.

  1. #1
    Join Date
    Sep 2009
    Location
    Flint, MI
    Posts
    16

    Default Trying to grab varying lines of info.

    This should be an easy thing to do and it seems like I've done it before, but drawing a blank for some reason. I need to pull the Balance amounts (bottom line for section), each payment above (if they had one), and the Company name. Seems like I would make the bottom line the detail template and those above simply as an Apend.

    There's no real pattern to the number of payments, anywhere from zero to five, but the overall layout is the same, meaning they all say Payment, Balance, Company name..etc.

    I just need a general push to get me going. Thanks

    Company A
    Payment 4,343
    Payment 544
    Payment 3,310
    Balance 132,130
    Company B
    Payment 400
    Balance 55,180
    Company C
    Balance 100,000

  2. #2
    Join Date
    Apr 2008
    Location
    Reading,Pa
    Posts
    419

    Default

    The payments would be your detail line, as they will be the many to one relation. Your Balance would be your footer and the company the header. My assumption this is from a payment report, and that each company has a payment.

  3. #3
    Join Date
    Sep 2009
    Location
    Flint, MI
    Posts
    16

    Default

    Most of them have payments, but not all of them.

  4. #4
    Join Date
    Sep 2008
    Location
    Munich
    Posts
    1,505

    Default

    Hello Amadeus,

    There's a few different ways to tackle this. Let's assume that every Company only appears once, and that every company has one and only one Balance. But we have a number of Payments for each Company that varies from 0-5 (the 5 can vary - but let's hope it's safe to say it never exceeds 40). As for the output, what exactly do you need? One record per Company?

    "Company";"Payment1";"Payment2";"Payment3";"Paymen t4";"Payment5";"Balance"
    "A";"4,343";"544";"3,310";"";"";"132,130"
    "B";"400";"";"";"";"";"55,180"
    "C";"";"";"";"";"";100,000

    or something else?

    Best wishes,

    Olly
    Olly Bond
    MONARCH | | Ň | EXPERTS
    http://www.monarchexperts.com
    mailto:olly@monarchexperts.com

+ Reply to Thread

Posting Permissions

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