Not Really a Subreport but....

[ALewis06]

I have 4 reports in Access 2007 that I have created. They are not very large; each report is about 10 rows with about 18 fields--they are all the result of Crosstab queries I created to mimic an old spreadsheet. In Excel, you can just copy & paste and place all 4 datasets into one worksheet. But how would I make them appear the same in Access? Would that be a subreport? How many subreports can you have in one report?

Is this even the right way to do this? Because I think Access is going to be looking to establish a relationship among the 4 reports.

 

[plog]

Is this even the right way to do this?

Probably not, but here's how:

Make a 5th report--completely blank, no data source. Then add your 4 reports to it as subreports--wherever and however you would like them to appear.

The right way in Access is to probably come up with another format--cross-tabs are a horrible query to build a report on. You should layout your data vertically. The actual right way is to export the data to Excel and continue with a format and file type everyone is used to. I mean, really, what's Access doing for you?

 

[ALewis06]

I'll do it! Thanks