First, let's define the fields we want to include in our query. This time, we set up the fields in Design view, instead of using the wizard. Design view will give us more control over how the query is set up.
In Design view, we will show the Donor Information table, and then drag the fields to the Design view grid.
We are preparing our lists for an upcoming banquet, so we really only need to display the donors' name and the state they are from.
To narrow down our list, however, we will also need to use the amount our contributors donated in our query, although we don't plan to display it in the list.
So we need to include the Amount Donated as a field in the query, but we will need to set this up as a range, such as between 1,000 and 5,000 dollars.
Later in this lesson, we'll show you how to specify that you don't want this field displayed in the query results.