I have created a report in Access 2000 from a table created at the end of a Macro run. The Report uses several layers of grouping/sub-grouping. I want my Detail section columns to wrap so that I have 4-columns each 1.75" in width and 0.1" seperating my columns. When I use the File/Page Setup/Columns-tab, I get the Detail to wrap into the proper columns, but the Header for the Detail Section and the Header above it wind up being covered up by the 4-Columns of the Detail Information. I need the Detial Header to display the titles correctly above the columns. I also need the next Header to display, because it is based upon the grouping running a count of records, suming up retail $values, and suming up $commissions of the detail records in the goup.
I have failed miserably and I don't want to just use one column in the Detial section, that causes my reports to be 40 pages insteady of 10 pages.
Please Help an old desperate man!
Topic Options
Post Options
Thanks(0)
