• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 11. Creating Multitable and Cros... > Designing Parameter Queries

Designing Parameter Queries

If you expect to run a summary or another type of query repeatedly with changes to the criteria, you can convert the query to a parameter query. Parameter queries—which Chapter 9 explained briefly—enable you to enter criteria with the Enter Parameter Value dialog. Access prompts you for each parameter. For the qryMonthlyOrders1997 query that you created in the preceding section, the only parameter likely to change is the range of dates for which you want to generate the product sales data. The two sections that follow show you how to add a parameter to a query and specify the data type of the parameter.

Adding a Parameter to the Monthly Sales Query

To convert the qryMonthlyOrders1997 summary query to a parameter query, you first create prompts for the Enter Parameter Value dialog that appears when the query runs. You create parameter queries by substituting the text with which to prompt the user, enclosed within square brackets, for actual values. Follow these steps:


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint