CHAPTER 13Performing Conditional Analyses
Until now your analyses have been straightforward. You build a query, you add some criteria, you add a calculation, you save the query, and then you run the query whenever you need to. What happens, however, if the criteria that governs your analysis changes frequently or if your analytical processes depend on certain conditions being met? In these situations, you would use a conditional analysis: an analysis whose outcome depends on a predefined set of conditions. Barring VBA and macros, there are several tools and functions that enable you to build conditional analyses; some of these are parameter queries, the IIf function, and the Switch function.
In this chapter, you learn how these tools and functions can help you save time, organize your analytical processes, and enhance your analyses.
Using Parameter Queries
You"ll find that when building your analytical processes, anticipating every single combination of criteria that may be needed will often be difficult. This is where parameter queries can help.
A parameter query is an interactive query that prompts you for criteria before the query is run. A parameter query is useful when you need to ask a query different questions using different criteria each ...
Get Access 2019 Bible now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
