Pushing data Orientation

[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

 

[Stefan Hoffmann]

hi Jai,

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 ,

Yes, you should use the pivot wizard, it is quite simple. Just give it a
try.


mfG
--> stefan <--

 

[Jerry Whittle]

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

 

[John W. Vinson]

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 ,

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