B
Bernhard
Hello friends,
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. For this
purpose I am using Active Docs v4.0, an application which
resides in Word (2003)and has the ability to link to
Access tables ,Select Queries, Excel Tables and other OLE-
type databases. Ideally, all the data for one document
should be contained on one row, in order to facilitate
data entry. Unfortunately, my data is structuted as
follows:
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.
My goal is to convert this Table to the following
linkable table stucture without too many intermediary
steps:
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 do not seem
linkable. There must be a way to do this in a dignified
fashion without resorting to exporting into Excel,
transposing rows and columns of the table and then
linking it from Excel, which would be time-consuming and
non-elegant and almost guaranteed to drive me nuts.
(help!)
Your answer is greatly appreciated.
Bernhard
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. For this
purpose I am using Active Docs v4.0, an application which
resides in Word (2003)and has the ability to link to
Access tables ,Select Queries, Excel Tables and other OLE-
type databases. Ideally, all the data for one document
should be contained on one row, in order to facilitate
data entry. Unfortunately, my data is structuted as
follows:
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.
My goal is to convert this Table to the following
linkable table stucture without too many intermediary
steps:
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 do not seem
linkable. There must be a way to do this in a dignified
fashion without resorting to exporting into Excel,
transposing rows and columns of the table and then
linking it from Excel, which would be time-consuming and
non-elegant and almost guaranteed to drive me nuts.
(help!)
Your answer is greatly appreciated.
Bernhard