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

Chapter 4. Creating Advanced Queries > Running Parameter Queries

Running Parameter Queries

Building a query is usually a get-it-right-and-then-forget-it proposition. That is, after you have your query returning the correct dynaset, you usually don't have to worry about the query design any longer. The data that appears in the dynaset might change as the records in the underlying tables are added, deleted, and edited, but the query itself remains static.

However, there are certain situations where the query itself undergoes regular change. For example, you saw earlier (see Figure 4.15) that you can use aggregate operations to determine how many units of each product remained after processing a certain day's orders. That query used a specific date as the criteria for the OrderDate field. If you want to see the results using another date, you need to edit the criteria. If you used a query like this often, you might eventually find that it's a real pain to constantly have to open the query design window, edit the query criteria, and then run the query.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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