Access 2010 Report with 40 questions that each require a different subreport
Within an Access Report, I have 40 questions. Each of the questions is listed within the Detail section of the report. For each of the questions, I need to be able to use a different subreport. How can I set up the subreport so that a different subreport is used for each of the forty questions.
I expect the aswer to your Q will be in the table/query structure.
Are you able to upload a sanitised sample of your DB?