We help IT Professionals succeed at work.

display footer of subreport on main report

jvoconnell asked

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

Mike EghtebasDatabase and Application Developer

In design mode of the report you want you want your information to be displayed ass a label (if you don't already have one). Let's say it is named lblMyLabel;

- bring up property sheet,
- click on the report footer (in design mode of course) in question.
- In property sheet select events.
- double click in the OnFormat event and click [...] button to the left of OnFormat event cell to access code window.

- Under Private Sub OnFormat() and before End Sub entter:

Me!lblMyLabel.Caption="Info goes here"

After you doe this, we will capture the information you want got to this label. This step one of two steps.

Mike EghtebasDatabase and Application Developer

typo... ass  should read add
          to the left  should read to the right


ok, step one completed.....

Thank you so far....

so much appreciated
Jeffrey CoachmanMIS Liason
Most Valuable Expert 2012

Can you post a sample of the DB you have so far, (with eghtebas' mods)?
...not sure I understand what else is needed

Sample database notes:
1. Back up your database(s).
2. Combine the front and back ends into one database file.
3. Remove any startup options, unless they are relevant to the issue.
4. Remove any records unless they are relevant to the issue.
5. Delete any objects that do not relate directly to the issue.
6. Remove any references to any "linked" files (files outside of the database, Images, OLE Files, ...etc)
7. Remove any references to any third party Active-x Controls (unless they are relevant to the issue)
8. Remove, obfuscate, encrypt, or otherwise disguise, any sensitive data.
9. Compile the code. (From the VBA code window, click: Debug-->Compile)
10. Run the compact/Repair utility.
11. Remove any Passwords and/or security.
12. If a form is involved in the issue, set the Modal and Popup properties to: No
    (Again, unless these properties are associated with the issue)
13. Post the explicit steps to replicate the issue.
14. Test the database before posting.

In other words, ...post a database that we can easily open and immediately see and/or troubleshoot the issue.
And if applicable, also include a clear graphical representation of the *Exact* results you are expecting, based on the sample data.


Business user requirements changed. There is not need to display the footer of a sub-report on the main report. All attempted solutions to this question are appreciated. Management has indicated that we spend no more time on this unless user requrements change. Thank you again.


Business requirements changed and a solution for this problem is not needed.

Explore More ContentExplore courses, solutions, and other research materials related to this topic.