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

  • Thread starter Thread starter Guest
  • Start date Start date
G

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calculated Item causes undue repitition in pivot table 2
Help required to code a '% of total' column 1
Pivot table sorting, should be easy I think 1
Lookup to create a table of data in terms of selection 1
PIVOT TABLES-PERCENT/AMOUNT OF CHANGE 3
Need help Refining a Macro & make more Robust. 2
Help I need a macro or IF Statement 6
Need to pivot my data from columns to rows 1

Back
Top