Multiple grouping and blank pages

I have a report with 2 types of grouping. The first is monthly and the second is basically a grand total. I want to have the report with 1 page per month with the grand total on the last page. Everything is in one table object, with two groups in the table footer.

The problem that I have is that if I put "Page Break After" on my Monthly grouping the total is going to end up on a different page at the end. If I put "Page Break Before" I get a blank page at the start. Anyone got a idea of how to get myself out of this?

Make sure the table starts from the top of the report, i.e. don't leave any empty space before the table. Then you shouldn't get the blank page.

We are working on improving this (adding a "page break between" feature) for the future releases.

Multiple connection type query

Hi everyone,
Is it possible to perform a SELECT/INSERT statement with two different connection types? I want to do the "SELECT" statement with data from SQL Server and "INSERT" it into an Access database all in one query.
Sanctosuse linked tables to sql server in Access and create your insert query in access.