Search results

Thanks! I do want the report to show: Answera. Answerb. Answerc. Each answer is in a separate record. So they are nat answera answerb and answerc but answer from record1 answer from record 2 and answer from record 3. I could concatenate them as you suggested in they were in the same record...

I have a program in Access 97 that I have been working on to interview my patients before I see them. They are asked multiple questions. The answers to these questions are in one table with one answer per record. I would like to be able to print these in a report in sequential order instead...