We help IT Professionals succeed at work.
Get Started

Access 2016 Subreport with Multiple Columns not Working

Cecelia Rieb
Cecelia Rieb asked
Last Modified: 2017-12-10
I have an Access report that I want to display 16 questions down the side, and the answers for various programs in multiple columns.  I created a report and embedded a subreport (against the same table as the main report) to display the data in multiple columns.  I have the subreport set to 2 columns, the Column Layout to Across then Down, and the subreport section in the main report is more than wide enough to handle the 2 columns of data.

The problem seems to come with the master/child fields.  Since the main report and the subreport have the same source table, I want the master/child relationships to be one-to-one.  In this case, that means two fields: Department and Program.  If I set the relationships this way, my subreport, which displays my desired 2 columns on its own, now only displays one column when viewing the main report in Print Preview mode.  If I change the master/child relationship to many-to many (i.e., on Department only, excluding Program), I then can see my 2 columns of data.  However, since it's a many-to-many relationship, instead of getting data for just the 9 programs, I get those same 9 programs repeated 9 times.

The fact that the many-to-many relationship shows me my multiple columns as desired tells me that the subreport itself is set up correctly, and that I've allowed enough width in the main report to accommodate two columns of data.  What is it about the one-to-one relationship that precludes me from seeing multiple columns?  I'm working on using a different source for the main report, which would make the master/child relationship one-to-many, but am running into the same problem.

Please help!
Watch Question
Distinguished Expert 2017
This problem has been solved!
Unlock 2 Answers and 11 Comments.
See Answers
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE