column - row transposition - HELP!!!!

[Bernhard]

Hello,

I presented this problem of mine a few days ago but did
not get a response. I will try to be clearer this time:

I want to populate a Word document with text data
(answers) contained in an Access (2000)database, which
gets a lot (!)of data input on a daily basis. I need to
change column to row data for the import into the text
file and would like to get some pointers as to how to
transform my data within access to achieve this. My data
is structured like this:

Column 1 Column 2 Column 2

Person A Question #1 Answer#1
Person A Question #2 Answer#2
Person A Question #3 Answer#3
Person B Question #1 Answer#1
Person B Question #2 Answer#2
Person B Question #3 Answer#3
etc.

I would like the resulting table (pre-linking) to look
like this:

Column 1 Column 2 Column 3 Column 4

Question #1 Question #2 Question #3
Person A Answer #1 Answer #2 Answer #3
Person B Answer #1 Answer #2 Answer #3


I have tried creating a Pivot-Table and I have
experimented with a Crosstable Query, both of which
display the data just the way I want them but they are
not linkable in the displayed form.

Thanks.

Bernhard

 

[John Nurick]

Hi Bernhard,

I'd probably use a crosstab for this. When you say "they are not
linkable in the displayed form", what are you trying to do and what's
happening?