[RESOLVED] dataReport has too many pages or listings

[wolf99]

Hi am fairly new to reports
am using vb6 DAO

I have a function that queries my access db then outputs the result to a label on the report, in form; partNum, number of parts with partNum, partFault.

Prob is, when I set the label in the detail section, with 3 items from a 10 record db, the label got printed 10 times over 3 pages.

So i moved it to the Page header and got 3 pages, each with the 3 items at the top. wether this is because this is space still used by the 10 records, just hidden, or because of the 3 records Im not sure.

anyhoo, I moved the label to the ReportHeader seection. now the label only prints once (Yay); but I'm still etting three pages, 2 extra blank ones after the first page!

how can i cut the pages to the number needed??

Also how can I ensure the page size is set to A4 and how to specifiy the printer used?

thanks in advance, muchos gracias!

[wolf99]

Oh, the extra pages dissapeared when I added stuff into the page footer...wierd.