Access 2007 Data to Excel
 

I am using Office 2007. I currently link to 10 queries in Access to create
an updateable report in Excel (management wants it in Excel). One query
after another is linked in one workseet viewed as tables. When the data is
updated the number of rows may change in the table causing many rows between
my subreports - one time I may have 52 states listed then only 10 the next
time so the next subreport after state will have 42 empty rows before it.


Is there a way to keep a consistent number of rows between subreports
without having blank rows in the subreport?