Columns vs rows

Normally when I run a query, each record is displayed in a row, and the
colums contain the field titles.

Is there a way to switch this and have each record in a column, and the
names of the fields would be the rows?



This will need to be exported to excel. That part I understand, just not
changing the rows and columns around.



Thanks

It might be possible to construct a crosstab query that will do this,
otherwise I don't think it's possible.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)



"RR" <texson552000@yahoo.com> wrote in message
news:Oyk1e.43053$8D.26153@tornado.texas.rr.com...[color=blue]
> Normally when I run a query, each record is displayed in a row, and the
> colums contain the field titles.
>
> Is there a way to switch this and have each record in a column, and the
> names of the fields would be the rows?
>
>
>
> This will need to be exported to excel. That part I understand, just not
> changing the rows and columns around.
>
>
>
> Thanks
>
>[/color]

Thanks for the response.

I've tried to get a cross tab to work, but I cant figure out anything that
would work. Crosstabs arent something I use a lot, so I am not sure of the
ins and outs of them.


"Douglas J. Steele" <NOSPAM_djsteele@NOSPAM_canada.com> wrote in message
news:4PSdnRRML-g5Q9jfRVn-iA@rogers.com...[color=blue]
> It might be possible to construct a crosstab query that will do this,
> otherwise I don't think it's possible.
>
> --
> Doug Steele, Microsoft Access MVP
> http://I.Am/DougSteele
> (no e-mails, please!)
>
>
>
> "RR" <texson552000@yahoo.com> wrote in message
> news:Oyk1e.43053$8D.26153@tornado.texas.rr.com...[color=green]
> > Normally when I run a query, each record is displayed in a row, and the
> > colums contain the field titles.
> >
> > Is there a way to switch this and have each record in a column, and the
> > names of the fields would be the rows?
> >
> >
> >
> > This will need to be exported to excel. That part I understand, just[/color][/color]
not[color=blue][color=green]
> > changing the rows and columns around.
> >
> >
> >
> > Thanks
> >
> >[/color]
>
>[/color]

Hi RR:

Here's a link to an article from the Microsoft Knowledge Base on exactly
your question. It gives 2 ways to accomplish your goal. I hope it helps.
It is for Access 97, but it should still work in later versions.

The article is named "How to Transpose Data in a Table or Query", it is
article Q182822. You can find it at the following url:

http://support.microsoft.com/default...b;en-us;182822

Good luck!

Alan

"RR" <texson552000@yahoo.com> wrote in message
news:Oyk1e.43053$8D.26153@tornado.texas.rr.com...[color=blue]
> Normally when I run a query, each record is displayed in a row, and the
> colums contain the field titles.
>
> Is there a way to switch this and have each record in a column, and the
> names of the fields would be the rows?
>
>
>
> This will need to be exported to excel. That part I understand, just not
> changing the rows and columns around.
>
>
>
> Thanks
>
>[/color]

RR,
Excel will paste/transform a range exactly as you ask. It's under the
Paste/Special dialogue. Since the data is headed to Excel anyway I'd
probably not bother with trying to get Access to do it. I'd have Access
output a worksheet with the data before transforming it. Then I'd have
Excel open the created worksheet and have it do whatever I needed.

"RR" <texson552000@yahoo.com> wrote in message
news:Oyk1e.43053$8D.26153@tornado.texas.rr.com...[color=blue]
> Normally when I run a query, each record is displayed in a row, and the
> colums contain the field titles.
>
> Is there a way to switch this and have each record in a column, and the
> names of the fields would be the rows?
>
>
>
> This will need to be exported to excel. That part I understand, just not
> changing the rows and columns around.
>
>
>
> Thanks
>
>[/color]

Thank you to both of you. Both of your answers were very helpful.


"Alan Webb" <knogeek@hotmail.com> wrote in message
news:E_WdnZQn_so_ndvfRVn-3Q@comcast.com...[color=blue]
> RR,
> Excel will paste/transform a range exactly as you ask. It's under the
> Paste/Special dialogue. Since the data is headed to Excel anyway I'd
> probably not bother with trying to get Access to do it. I'd have Access
> output a worksheet with the data before transforming it. Then I'd have
> Excel open the created worksheet and have it do whatever I needed.
>
> "RR" <texson552000@yahoo.com> wrote in message
> news:Oyk1e.43053$8D.26153@tornado.texas.rr.com...[color=green]
> > Normally when I run a query, each record is displayed in a row, and the
> > colums contain the field titles.
> >
> > Is there a way to switch this and have each record in a column, and the
> > names of the fields would be the rows?
> >
> >
> >
> > This will need to be exported to excel. That part I understand, just[/color][/color]
not[color=blue][color=green]
> > changing the rows and columns around.
> >
> >
> >
> > Thanks
> >
> >[/color]
>
>[/color]

Actually using the function would be the prefered method, but whenever I try
to use it I get the 3190 too many fields defined error, no matter how small
the table is.

I'm using access 2002. Any guess why i am getting this error?


"Alan Lane" <awelane@yahoo.com> wrote in message
news:EVl1e.46704$VD5.115@twister.socal.rr.com...[color=blue]
> Hi RR:
>
> Here's a link to an article from the Microsoft Knowledge Base on exactly
> your question. It gives 2 ways to accomplish your goal. I hope it helps.
> It is for Access 97, but it should still work in later versions.
>
> The article is named "How to Transpose Data in a Table or Query", it is
> article Q182822. You can find it at the following url:
>
> http://support.microsoft.com/default...b;en-us;182822
>
> Good luck!
>
> Alan
>
> "RR" <texson552000@yahoo.com> wrote in message
> news:Oyk1e.43053$8D.26153@tornado.texas.rr.com...[color=green]
> > Normally when I run a query, each record is displayed in a row, and the
> > colums contain the field titles.
> >
> > Is there a way to switch this and have each record in a column, and the
> > names of the fields would be the rows?
> >
> >
> >
> > This will need to be exported to excel. That part I understand, just[/color][/color]
not[color=blue][color=green]
> > changing the rows and columns around.
> >
> >
> >
> > Thanks
> >
> >[/color]
>
>[/color]