breakpoints across the page rather than down

[Roni Sutton]

I have created a report grouped by date that breaks appropriately down the page. However, the user wants the information to go across the page instead. Is there a way to cause breakpoints to print across rather than down? I realize I will have to make this a landscape report. As it will ALWAYS be a rolling 13 months, it will never get any wider than it is originally created, so there is no concer around varying width. Has someone out there ever done this?

Thanks, Roni

 

[Pat Hartman]

You will need to create a crosstab query to accomplish this. You will also need to modify the column headings on the fly since they will change from month to month. There is an example of how to do this in solutions.mdb.