Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Grand Total wrong when report is printed
Hey, Pete, thank you for your rapid response. U wrote: you could use txtGrand.Value = DSum("Money","QryName") I can't do this because a project ID changes for each detail line. U wrote: otherwise you could use =Sum([Money]) as the txtGrand's control source. I assume that you meant...- KentHuck
- Post #3
- Forum: Microsoft: Access Reports
-
Grand Total wrong when report is printed
A report's Grand Total (txtGrand below) displays correctly in Print Preview. However, it is incorrect when Printed. The Detail field (txtMoney) is derived from a query (because the report is too complex for only one query). Therefore, the Grand Total is accumulated in code in the variable...- KentHuck
- Thread
- Replies: 7
- Forum: Microsoft: Access Reports
