Page 2 of 20PREVNEXT

Queries III: Create parameter queries that prompt users for input

Parameter queries can answer multiple questions

One parameter query can answer multiple questions.

You're probably familiar with the basic Access select query. To create a select query, you choose its structure and criteria, such as sales figures for a specified month.

But what if you want to search for different months every time you run the query? Today you may want sales figures for September, but next week you might need them for April.

A parameter query enables you to enter different criteria each time you run the query. You can get just what you need, without having to recreate the whole query in the process.

To continue reading this lesson on your own, click Next.

Page 2 of 20PREVNEXT