Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Report header totals

Report header totals

Report header totals

I have written a monthly report with Employee and Week groupings and totals. In the OnPrint event of the Employee Footer I accumulate totals for Department against Pay Rate in module defined variables. The report runs to about 50 pages for 20 employees.

The Report Footer layout contains 20 rows of 9 columns of Unbound Text Boxes ready to hold descriptions and totals. Within the OnPrint event of the Report Footer I lay out the required data according to the number of rows and columns containing non-zero totals; this entails hiding and moving/resizing some of the Text Boxes. Row and column totals previously accumulated are printed in the right hand column and in the row immediately below the final non-zero row (usually about 14 rows).

The report is produced in Preview mode and may be viewed before printing or immediately printed using the print icon. On some occasions the values will be doubled (or possibly other values), recreating the report will usually result in correct values being produced. Attempts to recreate the error situation are always a failure. I have been unable to determine the exact situations when totals are incorrect.

I hope I have provided a clear description of the problem. Any help would be appreciated.

RE: Report header totals

I would try initialize all of the variables in the On format or print of the Report Header section.

Hook'D on Access
MS Access MVP 2001-2016

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close