Hello,

I have a rport in Access that prints a total out a total amount at the end of each month in the footer. It works perfect if I am pre-veiwing the report or if I prin the whole thing off. However, and this crazy, when I want to print page 10 of lets say 20 that total that is correct on my screen is printed out wrong. I have tried playing around with the running sum property but that just gives me different versions of the wrong answer. Anyone heard of this before. Thanks in advance

I've run into this also. I think it is a "feature". Access does not actually print the page you are viewing (and this makes sense because you can specify any page number range in the print dialog) but recalculates the report up to the page you asked to start printing. However, I would guess, based on its behavior that it does not go through all the formatting steps but rather just calculates the record number that would appear on the page you want to print by figuring out how many records would print on each page. Since it does not go through all the formatting steps, it would not execute any code you have in the various events or be able to calculate a running sum acurately.