CODEWITHSUNDEEP
databasems-access
Vinod GH
Vinod GH

Reputation:

Query(ms access) to Turn rows to column

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

Upvotes: 0

Views: 1242

Answers (1)

Robert Harvey
Robert Harvey

Reputation: 180788

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.

Upvotes: 2

Related Questions