Pushing data Orientation

  • Thread starter Thread starter Jai_Friday
  • Start date Start date
J

Jai_Friday

Morning ,

I didnt know which area to post this as the answer could be query, report or
macro

I wish to know if there is a way to push data to from top down to left to
right

example is , from an ODBC link I gather turnover figures for customer over
months which by default exports as follows

Customer Month Turnover
ABC Ltd Jan 09 £100
ABC Ltd Feb 09 £200
ABC Ltd Mar 09 £300
ABC Ltd Apr 09 £400

What I would like to do is automatically bend the data so I get it on a
single line and the change in Months seperate into columns

Customer Jan 09 Feb 09 Mar 09 Apr 09
ABC Ltd £100 £200 £300 £400

I think Pivot Tables could be a solution but not really used them ,

Thanks in Advance

Jai Cutmore
 
hi Jai,

Jai_Friday said:
Customer Month Turnover
ABC Ltd Jan 09 £100
ABC Ltd Feb 09 £200
ABC Ltd Mar 09 £300
ABC Ltd Apr 09 £400

What I would like to do is automatically bend the data so I get it on a
single line and the change in Months seperate into columns

Customer Jan 09 Feb 09 Mar 09 Apr 09
ABC Ltd £100 £200 £300 £400

I think Pivot Tables could be a solution but not really used them ,
Click to expand...
Yes, you should use the pivot wizard, it is quite simple. Just give it a
try.


mfG
--> stefan <--
 
You need a crosstab query. Access has a wizard to help you create one. You
may need to give it a couple attempts; however, a crosstab query will produce
the data like you want to see it. There is one catch: Access will probably
create the column headings across alphabetically isn't of by month and year.
You can over ride this by specifying the column headings.

Allen Browne has a lot of info on crosstab queries.

http://allenbrowne.com/ser-67.html
 
What I would like to do is automatically bend the data so I get it on a
single line and the change in Months seperate into columns

Customer Jan 09 Feb 09 Mar 09 Apr 09
ABC Ltd £100 £200 £300 £400

I think Pivot Tables could be a solution but not really used them ,
Click to expand...

A Crosstab Query is probably your best solution. See the Help for that term.
 
Back
Top