Page 9 of 20PREVNEXT

Queries III: Create parameter queries that prompt users for input

Setting up fields in the Query Wizard

Move the fields you want to include in your query from Available Fields to Selected Fields.

The first step in setting up a parameter query is specifying the data you want to include in the query, such as information about customers, sales orders, or donors.

You can do this by using the Simple Query Wizard or Design view.

In this example, we'll set up the query by using the wizard, which will prompt you to specify the table you are basing your query on. In this case, we will use the Donor Information table.

We want to include the donor's name and address information in this list. We do not need to include the amount of money donated.

Page 9 of 20PREVNEXT