Repeating Sections in Report (Combo Boxes)

[bburton]

I am having a problem with generating a report. It has a section within the report that repeats itself. I understand that this is actually caused by the multiple fields within the table it pulls the data from.

However the reason I have multiple rows of fields in that table is because I had those fields provide the data to a query to input combo boxes on the form. After they select an option from the combo box, I would then need the information to show on the report without it repeating itself.

My guess would be that I'm not doing the combo boxes the way I should be doing them.

How could I still produce a combo-box with selections of different values, which would still show on a report but not cause it to repeat?



Here are some images to help show what I've done.

Table:


Form:


Query:


Report:


Thanks!

[bburton]

Nevermind, I just did an alternative way that'll work for now. I moved the stuff that was in the details section into the header section instead where it won't repeat.