Access 97 crossTab Report

[pvje]

I have a need for a report that breaks on contract and has two columns per page.

I have it working sort of I have defined the number of columns as 2 and across then down in page setup.

it works but if there is an odd number of columns per contract, it puts the first column of information under the old contract and then page breaks and resumes.
I understand its trying to put the two columns since that is how I define the number of columns

can this be done?

 

[dhookom]

I'm not sure how you have your columns setup to dynamically display your columns. The most flexible method is found in the Crosstab Reports at

http://www.invisibleinc.com/divFiles.cfm?divDivID=4

Duane
MS Access MVP
Find out how to get great answers faq219-2884.