This Access tutorial explains how to keep a group together in one page in Access Report. You may also want to read: Access Report group by date problem Access Report - keep a group together in one page In Access Report, you can group a Field and then display the grouping in Group Header, and display the value in Details. Sometimes the Details may be so long that it extends to the next page, breaking up the same group into two pages. Access Report has a function called "group together i...

This tutorial shows how to link Access to external ODBC data source. Access link to external ODBC data source ODBC (Open Database Connectivity) is a standard programming language middleware API for accessing database management systems (DBMS). The designers of ODBC aimed to make it independent of database systems and operating systems. The reason for connecting Access to ODBC is that Access can directly get database data once the connection is setup, saving a lot of time to make  Query thro...

This Access tutorial explains how to hide Subreport if no data. You may also want to read: Access Report reset total page number and insert blank page Access Report page break by Group and add blank page Hide Access Subreport if no data Assume that you have a Master Report called Report A, the figures are displayed in Group Header. Now you have a Subreport called B and you want to display data for each Group Header. Drag Report B to A and define the joined Fields. As you...