Generating Summary Report in Access?

[yingying001]

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.

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?

To me, mail merge isn't working that well.

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!

 

[Duane Hookom]

There is a generic concatenate() function and sample usage at
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane. This
might help depending on your table structure. I expect you have an issue
with normalization that might be resolved with a union query.