I inspmike Guest Feb 2, 2000 #1 How do I get the report to page break at the end of each month with a sub total, then to give me a grand total at the end of the report?
How do I get the report to page break at the end of each month with a sub total, then to give me a grand total at the end of the report?
D dennyryan Registered User. Local time Today, 06:56 Joined Dec 21, 1999 Messages 45 Feb 10, 2000 #2 Add a caclulated field to your query: Month:month(DateField) Then in your report make this new field one of your grouping fields with a footer. You add the sub-total fields in the Footer section. You can also chnage the Format Property for the Footer to Force New Page: After section Denny
Add a caclulated field to your query: Month:month(DateField) Then in your report make this new field one of your grouping fields with a footer. You add the sub-total fields in the Footer section. You can also chnage the Format Property for the Footer to Force New Page: After section Denny
