Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Form Question (I think): Need to create columns of data as well as

Discussion in 'Information Technology' started by Shaun Rucker, Jul 28, 2006.

  1. Shaun Rucker

    Shaun Rucker
    Expand Collapse
    Guest

    I have some data I pull with a query and make a pivot table in excel with
    currently, but I want to just create a report that does this for me, so I
    don't have to do any work on it. The format I need is as follows:
    Company Code
    Account # 1000 1100 1200 9000 9010 Total
    123456 $100 $0 ($250) $0 $400 $250
    111111 ($500) $250 $0 $50 $10 ($190)

    Total ($400) $250 ($250) $50 $410 $60

    So, we're listing all account #'s down the left side, with each company code
    listed across the top, and the amounts for each account and company code
    listed under the appropriate spot. I'm sure this is possible somehow, but my
    knowledge is not sufficient to do this. Help?!
     
  2. Loading...


  3. Allan Murphy

    Allan Murphy
    Expand Collapse
    Guest

    Shaun

    You could use a crosstab query with Account as your Row Heading and Company
    Code as your Column Heading and sum on amount to give the total for account
    number per company code.

    Then use report footer to give the Totals etc.

    --
    Allan Murphy
    Email: allanmurphy@unwired.com.au


    "Shaun Rucker" <ShaunRucker@discussions.microsoft.com> wrote in message
    news:414A1F8A-309D-4FE2-98EA-6686A5F555D3@microsoft.com...
    > I have some data I pull with a query and make a pivot table in excel with
    > currently, but I want to just create a report that does this for me, so I
    > don't have to do any work on it. The format I need is as follows:
    > Company Code
    > Account # 1000 1100 1200 9000 9010 Total
    > 123456 $100 $0 ($250) $0 $400 $250
    > 111111 ($500) $250 $0 $50 $10 ($190)
    >
    > Total ($400) $250 ($250) $50 $410 $60
    >
    > So, we're listing all account #'s down the left side, with each company

    code
    > listed across the top, and the amounts for each account and company code
    > listed under the appropriate spot. I'm sure this is possible somehow, but

    my
    > knowledge is not sufficient to do this. Help?!
     

Share This Page