Hello, I am a relatively new access user so please keep in mind that I am not well versed.
I have created reports that summarize frequencies and percentages across various questions in a form. I started by using a blank report template, adding existing fields from tables as necessary, and building expressions in the control source mostly using the Sum IIf function. the report is being generated as expected except that it looks to be repeating itself across multiple pages where I would only expect and want it on one page. The information across pages is all duplicative. If I were to guess, it is generating a detail section on a new page for every record in the corresponding table. I have spent a lot of time reading other posts about this issue but have not been able to fix it. Any assistance would be greatly appreciated. I would like to finish this database as soon as possible.
Thank you!