Clever Geek Handbook

How to transfer rows and columns in Access 2003?

How to wrap rows and columns in Access 2003? I have several tables that I need to do.

(I've reformulated my question because the feedback tells me it's confusing, as I originally stated it.)

Each table has 30 fields and 20 records.
Let's say my fields are Name, Weight, Zip, Quality4, Quality5, Quality6, Quality 30, which is a favorite movie. Let it be said that the records describe a person. People - Alice, Betty, Chuck, Dave, Edward, etc. Through Tommy.

I can easily make a report like this:

  >>Alice...120....35055---etc, etc, etc...Jaws  
  Betty....125....35212...etc, etc, etc...StarWars  
  etc  
  etc  
  etc  
  Tommy...200...35213...etc, etc, etc...Adaptation

But what I would like to do is wrap these rows and columns so that my report is displayed like this

  >>Alice........Betty......etc,etc,etc...Tommy  
  120.........125........etc, etc, etc...200  
  35055.....35212....etc, etc, etc...35213  
  etc   
  etc  
  etc  
  Jaws...StarWars..etc,etc,etc...Adaptation

Thanks for any help.

+2


source to share


4 answers


Access actually has a transposed verb, crosstab. You will find good things if you search for crosstab, which is the more common database to say this. As a knowledge base article . Common database responses usually include transpose and summation. If you want a pivot crosstab it can be done, but you will most likely need a custom function.



+2


source


Thanks everyone for your help. I believe I found the answer and I put a link to it here in case anyone needs it in the future: http://support.microsoft.com/kb/202176 <w> (This works for Access 2003.)



+2


source 


TRANSFORM SUM(Weight)
SELECT "Dummy Data"
FROM myTable 
GROUP BY "Dummy Data"
PIVOT [Name]

Does it help?

EDIT: This assumes the names will not be repeated.
that is, there will be no more than 1 entry for a given name.

0


source


I had the same problem and in the end I resorted to exporting the table to Excel, doing the transposition, and then importing it back into Access again.

0


source






More articles:


All Articles