One page report, copied 3k times.

[SirStevie3]

So i have a union query pulling together about 3,000 records from other queries.

I arranged all the counts and data I need to fit onto one page, but the report is copying that page (minus the header) for each record in the union query. I'd much prefer a one page report rather than a 3,000 page report.

Why does it do that? All I want is a one page report, how can I make that happen?

Thanks guys!! Much appreciated.

 

[pbaldy]

It sounds like maybe you put fields into the detail section of the report, and you really want them in the report footer or something. The detail section will print for every record in the source.

 

[SirStevie3]

Oh. well yes, im still new to access in general, so in order to create the report i pulled a field from the field list and put it in the detail section. then i copy/paste/edit to get the rest in place.

beautiful. I just copy/pasted it all to the page header section and it worked perfectly.

THANK YOU!!

 

[pbaldy]

Happy to help!