Query(ms access) to Turn rows to column

Question

I have table with column in ms Access

       Cost
      Repair
      Maintainance
      Wear
      Fuel

i want this rows as

    Repair  Maintainace Wear Fuel

as separate column as shown above

Duplicate: stackoverflow.com/questions/1052248/converting-rows-to-column; stackoverflow.com/questions/1047498/… — glasnt
– glasnt, Commented Jul 13, 2009 at 3:44
Those questions are both duplicates of each other, and neither one has the correct answer in it. — Robert Harvey
– Robert Harvey, Commented Jul 13, 2009 at 4:08
In all fairness, there are answers in the questions, but the people posing the question haven't been seen since asking the questions, so they can't have accepted any of the answers. If they are anything to go by, this may occur again with this question. — glasnt
– glasnt, Commented Jul 13, 2009 at 6:10

Robert Harvey · Accepted Answer · 2009-07-13 04:13:04Z

2

You can do this with a Crosstab query. There is a wizard in the Access Queries window that will walk you through creating one. Just click the New Query button and select the Crosstab Query Wizard.

edited Jul 13, 2009 at 4:13

answered Jul 13, 2009 at 4:06

Robert Harvey

182k48 gold badges349 silver badges516 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Query(ms access) to Turn rows to column

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related