- Use conditional analysis
In our discussion so far, getting information from Access databases has been a matter of creating queries, adding criteria and calculations, saving the queries, and then formatting the data into reports that can be run over and over as needed. Conditional Analysis comes into play when the basis of the analysis is in a state of flux or may otherwise need to change. Using parameter queries in Access is a solid approach to deal with this condition.
In the example below, a query is being prepared to display data regarding Purchase Order shipped and invoice dates. A hard-coded date is a criteria for the query.
But what if users from different departments need the flexibility to fetch this information from different time periods? Notice how this draft query has been changed to a conditional query by bracketing user instructions in the example below.
Now when the query is run, this dialog box would open and display the bracketed text to give the user the opportunity to enter the desired date of the analysis.