In our last practice exercise, we learned how to generate reports summarizing data. What if you want to generate the same type of report, but current for each month? If you used a regular query, or even a crosstab query, you would have to re-create the query every time you wanted to use it.

 

This is where parameter queries can come in handy. A parameter query prompts you for information before the query is run. So, for example, you can specify a date range for the query.