Share this Page URL

Chapter 10. Presenting Data with Reports > Working with a Report in Design View - Pg. 347

Presenting Data with Reports 347 9. 10. In the Detail section of the report, select the ProductName text box, and then move the text box to the ProductName Header section, positioning it below the label for ProductName that's included in the report's page header. Move the Quantity text box to the ProductName Header section as well. Right-click the Quantity text box, and then click Properties. In the Properties dialog box, click the Data tab, and then enter =Sum([Quantity[) in the Control Source property box. By entering this expression, we set up the report to display the total quantity ordered for each