Greetings one and all,
I have a problem with an Access 2000 report for which I cannot find an answer so any assistance you can provide would be great. The report is a statement of account, similar to a bank statement, which lists all relevant transactions with a running sum balance on each row together with a carried forward balance at the bottom of each page and a brought forward at the top of the subsequent page.
The carried forward amount for each page is accrued in the print event of the detail section where the page total = page total + row.
The brought forward amount on the following page is generated in the format event of the page header where it is set to the value of the carried forward amount.
All works well when printing or complete review in print preview, the issue is when the user skips pages in print preview say from page 3 to page 7. Then when viewing page 7 the carried forward balance in the page header contains the value of the page footer from page 3 not page 6.
I am tempted to suppress the carried forward figure in print preview but I can't work out which view the report is in.
So any suggestions on either:
1. How I can maintain a carried forward balance that would survive the page skip without doing an additional sum query for each row as the underlying linked SQL table is large (1 million rows+), or,
2. Derive the current view type and suppress the field whilst in print preview.
gratefully received.
TIA
Kevin
I have a problem with an Access 2000 report for which I cannot find an answer so any assistance you can provide would be great. The report is a statement of account, similar to a bank statement, which lists all relevant transactions with a running sum balance on each row together with a carried forward balance at the bottom of each page and a brought forward at the top of the subsequent page.
The carried forward amount for each page is accrued in the print event of the detail section where the page total = page total + row.
The brought forward amount on the following page is generated in the format event of the page header where it is set to the value of the carried forward amount.
All works well when printing or complete review in print preview, the issue is when the user skips pages in print preview say from page 3 to page 7. Then when viewing page 7 the carried forward balance in the page header contains the value of the page footer from page 3 not page 6.
I am tempted to suppress the carried forward figure in print preview but I can't work out which view the report is in.
So any suggestions on either:
1. How I can maintain a carried forward balance that would survive the page skip without doing an additional sum query for each row as the underlying linked SQL table is large (1 million rows+), or,
2. Derive the current view type and suppress the field whilst in print preview.
gratefully received.
TIA
Kevin
