We have a variable N, so repeating the records would work
for only one use of the file. We need to use the file as a
template, allowing for N to be any number (typically
ranging from 10 - 200).

We are working with survey data. For each question we are
showing the frequency distribution of responses, the mean,
and the standard deviation. Each value is in a cell across
the top of the spreadsheet. For example, the frequency of
respondents selecting A for question 1 is in cell A1, the
frequency of respondents selecting B for question 1 is in
cell A2, etc.

This part works fine because there is only one value
reported for each result.

The problem we're having is trying to display the comments
that go with each question. Each quantitative question
(likert scale) is followed by an open ended question. We
want the Word document to show the summative data for the
quantitative question and then list the responses to the
open ended questions.

We are able to do this through only the first question.
The quantitative data appears at the top, the open ended
responses are listed below using:

<Q1-example><Next Record>
<Q1-example><Next Record>

This list continues for up to 200 rows, allowing between 1
and 200 reponses.

Then, we insert the fields for question 2, the same as
question 1, and nothing comes up for the Q2 examples. The
reason for this is that Word is looking down the Excel
file at a row that is below the end of the data. We need
Word to return to the first record.

Does this make sense?

Thanks,

Kelly