Understanding Code execution in Reports

[BarkerD]

I have created a fairly complicated report which provides Delivery Ratings for a specified period based on very specific criteria.

The report doesn't give me the output that I expected. I have examined the code in great detail, and it SHOULD work properly. I have stepped through the code for a portion of the code to make sure it works, but not through the whole, since there are thousands of iterations.

My Questions:

1. When I Dim a variable, can it go out of scope before the report is completely formatted? I am using module level variables.

2. My counters re-initialize when the section header is formatted. How can I prevent this when the header is being re-formatted because of a new page?

There are probably other things I am missing....

Thanks

Duane Barker

 

[BarkerD]

Thanks Pat.

I don't know why I didn't think about using the footer. I don't believe I have scope problems, I think that the detail section is being formatted more times than I realize. I will have, say 100 iterations expected, and my coutner will be 800 or so. This really causes a problem with my statistics.

Duane Barker

 

[BarkerD]

Thanks, Pat. I will look it up

Duane Barker