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

Chapter 4. Creating Advanced Queries > Creating Queries That Make Decisions

Creating Queries That Make Decisions

The queries that you've seen so far in this book have been used to perform one or more of the following tasks: sorting, filtering, and calculating. This is what most business queries do, and you've seen that Access offers some slick techniques and features that enable you to create very powerful and useful sorts, filters, and calculations.

But queries are also a useful analytical tool that can be pressed into service to help you make decisions. For example, the query from the previous section returned the number of units left in stock. If you see a negative number returned, obviously a product is going to be backordered so you need to contact the supplier right away. However, some products also have a specified reorder level, which is the minimum number of units that need to be in stock before the product is reordered. So rather than wait for the stock to get to 0 (or less), you might need to reorder when it gets down to 25 units or 10 units.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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