View Single Post
 
Old 04-22-2021, 09:58 AM
dlconnolly@mac.com dlconnolly@mac.com is offline Windows XP Office 2019
Novice
 
Join Date: Apr 2021
Posts: 4
dlconnolly@mac.com is on a distinguished road
Default Using Merge Code to list question responses in multiple reports

I have a spreadsheet created from end of course surveys and am trying to merge the responses into reports for each instructor, grouped by the courses.

I am basing this on instruction from Mail Merge with Grouping.

My test with the first question in the survey worked fine. But, we have 20 questions and the collective answers that need to be in each report. When I tried to add the second question, that's when it got wonky.

The first attempt produced reports with
Question_1: the question written out once and all of the answers listed below
Question_2: the question written out with every answer
This is just for situational awareness since the code wasn't saved when I tried to fix it.

I tried to fix it with the code seen in MergeQuestion_code_example.jpg
The results of this code can be seen in MergeQuestion_merge_example.jpg
The results didn't even include Question_2 or it's values.

A shot of the table I am working with is MergeQuestion_table_example.jpg

I realise this method may require met to type a ton of code using the fn/F9 method. That's okay for now.
Reply With Quote