[Doug Robbins - Word MVP]

I think it would be best if we back up a bit. How is the information
recorded during the research interview?

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

wrote in message
oups.com...
Thanks for the reply.

Sorry I am new in this - my another question is when I set up the table
in the source data for the 20 symptoms, do I use each column for each
symptoms? Also, when I set up link in the main document to different
tables in Access, it doesn't work for me.

I am mainly dealing with one record (patient) at a time, rather than
mass records.

Is there any reading material on how to generating report using data in
Access? I know the how to create table in access, but that's more like
a data analysis than a report in word.

Thanks again,
Tracey


Doug Robbins - Word MVP wrote:
In the Word Mail Merge main document, you would use If...then...Else
field
constructions that evaluated the status of the checked field and either
inserted the symptom of skipped it depending on the status. You would
need
these fields in both sections of your main document.

You may however be better off using a report in Access as that is where
your
data is stored.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

wrote in message
ps.com...
Hi I am trying to set up a form letter for medical research interview
use. After interviewing each research patient, and based on the
patient's answers to a series questions, we generate a summary report
in Word document.

In the main document, I can set up merge for name, age, gender etc.

The challenge for me is this: there are, for example, 20 possible
symptoms. If the patient checked 5 of the 20, I will need the 5
symptoms to show in one area of the report, and the rest 15 go to a
different area in report. How do I accomplish this? Especially how do I
set this up in the source file ( I use Access).

I am pretty new in this, any help will be greatly appreciated.

Can anyone share a template with me if you have one that's similar?
Thanks!