By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,594 Members | 3,459 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,594 IT Pros & Developers. It's quick & easy.

how can I rotate a table so some of the current rows become column headings?

P: n/a
Col
My table has rows that list type of pay with YTD pay for each as well
as an employee ID number. I want to make the type of pay the column
headings and have each row contain an employee id# and the YTD amount
for each type of pay. Currently each type of pay is a different records
- need the employee ID as one records with all types of pay listed.
Thoughts?

Aug 22 '06 #1
Share this Question
Share on Google+
3 Replies


P: n/a
use a crosstab query

Aug 22 '06 #2

P: n/a
Col
Hi - I've never used a crosstab query, but i thought I they were used
to do some sort of calculation. I don't need to calculate. I just need
to more some of the rows so they are column headings. I appreciate any
help you can offer.
pi********@hotmail.com wrote:
use a crosstab query
Aug 23 '06 #3

P: n/a
Col
I think I'm all set now!
Col wrote:
Hi - I've never used a crosstab query, but i thought I they were used
to do some sort of calculation. I don't need to calculate. I just need
to more some of the rows so they are column headings. I appreciate any
help you can offer.
pi********@hotmail.com wrote:
use a crosstab query
Aug 23 '06 #4

This discussion thread is closed

Replies have been disabled for this discussion.