Access printer problem format.

[boreed]

I'm still learning the report feature in Access 97 and can use some help. I had a report that printed mailing labels (7 down and 2 across) that was working fine. I wanted a cover sheet that described the list, listed the date and time, and how many records there are. I put the information in the Report Header and it works (kind of).

My problems are these. The labels were set up with two columns. Access wants to do the same thing with the report header even though I only want one column. Also, after putting stuff in the report header the labels no longer print 2 across.....only 1. I haven't been able to figure out how to make the report header print on one page and the mailing labels print in 2 columns.

Am I doing this the right way or is there a better way? Also, is it possible to list the total number of records and pages printed on the Report Header?

Thanks. Any help would be appreciated.
Bob R.

 

[ghubbell]

Hi Bob,
I think the only way you'll win this one is to create a subreport which is two column and place it into your main report (one column). This is really very easy if you let the wizard build or rough out each report for you, then with your "main report" in design view, and your wizard (wand & stars) button depressed, click on "subform/subreport" and drag out its rough size onto your main report. The wiz should take care of the rest! Hope this helps, Gord
ghubbell@total.net