Pushing data Orientation

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 wrote:
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 --

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
--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.


"Jai_Friday" wrote:

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" schrieb im Newsbeitrag
...
hi Jai,

Jai_Friday wrote:
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 --

On Wed, 4 Nov 2009 02:31:01 -0800, Jai_Friday
wrote:


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

John W. Vinson [MVP]