Columns vs rows

[RR]

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

[Douglas J. Steele]

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" <te**********@yahoo.com> wrote in message
news:Oy******************@tornado.texas.rr.com...

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

[RR]

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:4P********************@rogers.com...

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" <te**********@yahoo.com> wrote in message
news:Oy******************@tornado.texas.rr.com...

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

[Alan Lane]

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" <te**********@yahoo.com> wrote in message
news:Oy******************@tornado.texas.rr.com...

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

[Alan Webb]

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" <te**********@yahoo.com> wrote in message
news:Oy******************@tornado.texas.rr.com...

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

[RR]

Thank you to both of you. Both of your answers were very helpful.
"Alan Webb" <kn*****@hotmail.com> wrote in message
news:E_********************@comcast.com...

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" <te**********@yahoo.com> wrote in message
news:Oy******************@tornado.texas.rr.com...

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

[RR]

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" <aw*****@yahoo.com> wrote in message
news:EV*****************@twister.socal.rr.com...

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" <te**********@yahoo.com> wrote in message
news:Oy******************@tornado.texas.rr.com...

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