one page report returns multiple pages

[Pogue]

OK here goes for my first post.
I have a report in Access 2000 that relies on controls that are coded thus: =Sum([field]="x" And [field2]="T&quot*-1. There are maybe forty controls on the page with similar criteria. When I run the one page report I get x number of pages depending I guess on the number of records that are found (the numbers it returns are accurate). When the user punches the print button for the 1 report, the printer goes nuts and prints out 96 copies or whatever. The only way to prevent this is to select file, print, pages 1 to 1 ok. The report depends on a macro. HELP!

 

[KerryL]

I've been engaged in the same battle for the last few days and received some valuable help from Jerry Dennison and others in the following two threads:

thread703-222192

thread703-179827


It seems to me there should be an easier way to override the "one-page-per-record" quirk, but if there is I haven't found it yet. If you figure it out, please share your discovery.

Good luck!

 

[Pogue]

Kerry,

Thanks for the direction. I got most of what I wanted to do, but haven't yet solved the whole thing. The page footer trick works, but I couldn't sum in it. P.S., does anyone know how to change my profile from (Programer) to (User) or whatever? I'm not a programmer.

Thanks