Report programmed?

[VBAhole22]

I have a table that stores the text of questions I pose to the user and another table that stores responses. Is there a way to get the text of the question to load into the report automatically, to save me hours of typing, and then have the answers right next to them?

 

[cogent1]

Do you always have the same questions in the report or do they vary from report to report? If they are standard, just copy and paste the question text into labels aligned to be opposite the fields containing the responses.

 

[Pat Hartman]

Since the questions are in a table and the answers are in another table, base the report on a query that joins the two.