Report Printing Problem

[Dominato]

When I view my report in Access, everything is fine. However, when I print the report, it prints different numbers then were displayed on the report on the screen. What's going on here? A few notes, I have a report and subreport. The subreport prints fine, but the reports numbers change. Only the calculated fields are screwy.

 

[Dominato]

Well its only a 2 page report and the values on the first and second page are correct on the screen. But when I print, the calculated values on the first page are doubled. The ones on the second page are fine. Oh well, nevertheless, thanks for the reply.

 

[Rich]

Which part of the report contains the calculations?

 

[Dominato]

The footer of one of my groupings. (Not the page or report footer)

 

[Lyn Mac]

From MS KnowledgeBase try this:

Enter the following code in the event procedure for the Format property of the page header:

Private Sub PageHeader_Format(Cancel As Integer, FormatCount As Integer)

' reset the counter for each new page

PageSum = 0

End Sub

Replace PageSum with the appropriate page variable.

HTH,

Lyn

 

[Dominato]

Thanks everyone. I got it fixed. It was very similiar to what you were all saying. I had to set all variables to zero then it worked fine. Thanks again.