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

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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/13728-form-question-i-think-need-create.html
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13728

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?!

 
Do share your immediate thoughts or reactions on this issue? We value your views! Login Now! or Sign Up Today! to share your views with us.. Gurfateh!

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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13728
number per company code.

Then use report footer to give the Totals etc.

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


"Shaun Rucker" 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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13728
> 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?!