Share this Page URL

Chapter 10. Presenting Data with Reports > Using a Parameter in Report Criteria - Pg. 356

Presenting Data with Reports 356 6. 7. 8. When we created the ProductsByCountry report, we based it on the CountryProducts table. By invoking the Query Builder in step 4, we're changing the report's record source to the query we've defined in this step. In a procedure such as this, you should be sure to add the fields already included in the report or the data in those fields will no longer be displayed. In the Criteria row for the Country field, enter the following to define a parameter: [Please enter a country name] On the Query menu, click Parameters. In the Query Parameters dialog box, shown here, enter the same prompt that you entered in step 6. In the Data Type column, be sure Text is selected, and then click OK in the dialog box.