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

Chapter 10. 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 8, "Designing Access Queries," explained briefly—enable you to enter criteria with the Enter Parameter Value dialog. Access prompts you for each parameter. For the qryMonthlySales query that you created previously in this chapter, 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 para-meter.

Adding a Parameter to the Monthly Sales Query

To convert the qryMonthlySales 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, 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