How to Use a Subreport in MS Access

In this episode, we're going to look at how to put a small report inside another report in MS Access. This is called creating a "subreport", and we'll be using the subreport object on a main form to display the subreport data, and to link the data to the particular row we are viewing. This will allow us to put a small descriptive report on each row of our current report, filtered to show just what we want to see. Let's go make a subreport!

Related Videos:
An Introduction to Reports in Microsoft Access
   • An Introduction to Reports in Microsoft Ac...  
How to Do Grouping and Sorting of Report Data in Microsoft Access
   • How to Do Grouping and Sorting of Report D...  
How to Use a Subreport in MS Access
You are watching this video now!
How to Return a Message Instead of an Empty Report in Microsoft Access
   • How to Return a Message Instead of an Empt...  
How to Use Nz in Microsoft Access to Handle Null and Empty Values
   • How to Use Nz in Microsoft Access to Handl...  
How to Format Dates in MS Access Queries, Forms, and VBA Code
   • How to Format Dates in MS Access Queries, ...  
2 Ways to Use a Calculated Column on Your MS Access Report
   • 2 Ways to Use a Calculated Column on Your ...  

Want to get access to premium content made just for you and have a chat with me? Find me on Patreon :

  / mackenziedataengineering  

Demo of my BZ RDP Cloaker:
https://www.patreon.com/posts/how-to-...



Want to work with me 1:1? Contact me today and book your free 20 min consultation!

Contact form you can find at http://www.mackenziemackenzie.com/

Follow me on social media:
  / mackenziedataanalytics  
  / seamacke  
  / seamacke  
  / seamacke  
  / psmackenzie  

Get Microsoft Office including Access:
https://click.linksynergy.com/fs-bin/...

Got a YouTube Channel? I use TubeBuddy, it is awesome. Give it a try:
https://www.tubebuddy.com/seanmackenz...


For developers looking for a new role, check out:
https://www.toptal.com/qKaO2b/worlds-...

Want my team to do a project for you? Let's get to it!
https://buy.billzone.com/smdeprojects...

   • How to Use a Subreport in MS Access