I have an Access report which includes a subreport. It prints fine in Access, but when I export it to Excel, the subreport begins in the next row and column of the main report.....example: the main report data is in Excel rows A1 thru Q111 - then the subreport begins in row R112 and uses as many columns as needed to the right (ends in AI113).
Is there any way to make the subreport align directly under the main report - that is to begin in cell R1????? Than x for your help!
p.s. I am NOT exporting using a VBA command - I am merely using the External Data icon to export the report to the Excel file. I could use the VBA command if I could append the subreport to the main report?????
Quickbooks hosting can do wonders to your enterprise but considering the points elaborated in the article which will help you to better analyze the outcomes. So scan your business, its needs and then move to the new world of limitless benefits.
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…