Search results for query: *

The report ended up with 7 subreports and logic using temp tables to get the 2 columns in the detail section. 2 temp tables (1 for each column) linked on record count to look like 1 row. I will clean up the code and post in near future along with lessons learned. Thanks, Bob

Duane, I think I understand. You some how sort the records so that an "across then down" column report looks like a "down then across". Please supply additional details. I know how to use dcount in a query to sequence (count) the records, but I can't get my head around how that helps...

Thanks for your comments Duane. My requirements for the report are down then across. I have played with settings in report properties with no luck and your comments confirm I can't get there using properties. I have tried two subreports representing the two columns. It somewhat worked, but...

My sample report has 185 records in a two column report with 2 subreports (single column) in the report footer. My columns are set to: down, then across. On page 3 of the report the last 30 records are in only 1 column on the left with empty space to the right. How to I get the remaining...