We help IT Professionals succeed at work.
Get Started

display footer of subreport on main report

jvoconnell asked
Last Modified: 2013-11-28

I am very inexperienced with Access reporting. I am hoping you may be able to assist. I have created two reports and put them on a single main report. For now everthing presented okay. The second report has a footer which consists of 3 labels which are a "key" that explains the target numbers.

I'll elaborate.....

 In Rpt #2, I just have the following lines:...

Diabetecs meeting HbA1c target   92%
Diabetecs not meeting LDL target 7%

But in the footer (**the Key)**, I have 3 static labels...

HbA1c targer:  <= 7.0
LDL targer : <= 100

This footer doesn't display when I combine report # 1 with this report #2.
My work around was just put this footer on the main report. Which worked fine.

We need to add a third sub-report to this report. So this will cause the data in the thrid reoprt to be in the middle  of the second report and the footer.

The business owner wants what was considered the footer (those three descrptive labes to appear directly before the data in the thrid report displays.

I cant figure out how to do that? I am a novice to Access.. And this solution must be in Access to accomodate the Business owners.

ANy assistance would be greatly apprreciated.
Watch Question
This problem has been solved!
Unlock 1 Answer and 6 Comments.
See Answer
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