The results of a survey make up a recordset in Access. There are nearly 400 questions, so for each person surveyed, there will be 400 records, each the answer to a question. I need to create a print-out of the answers from one person. Because of the formatting required, I planned to merge to Word.
Typically a merge uses multiple fields of one record in Access. I want to use a single field from multiple records. Can I do that? I think I'm going to run into problems!!