For an overview of the Advanced Query Wizard and its controls, see Advanced Query Wizard Overview.
- From the menu toolbar, click Reports > Queries > Advanced Query Wizard.
- Ensure that Create new query is selected at the top of the Query Wizard window.
- From the Query Type panel along the left side of the window, choose the Forms.
- In the Purpose of this Query section, ensure that General is selected.
- Click Next. The Step 2 window of the Advanced Query Wizard opens.
- In the Available Fields frame to the left of the window, ensure that the Output radio button is selected.
- Double-click a form that you would like to query. It will appear in the Output Fields frame in the center of the window.
- Click the Sort radio button at the bottom of the Available Fields frame.
- Double-click the criteria you want to you to sort on. The criteria that you selected will appear in the Sort Fields frame to the right of the window.
- To filter on form content data other than the keywords, click the Filter radio button; then, click field that you want to filter on. The Add Filter Criteria box will open.
- Choose the Operator that you want to use.
Note: Multiple filters are, by default, connected by the AND. For example, Donor Address Primary? Equals “Yes” AND Donation Received Date is between “01/01/2006”, “08/13/2008”. This means that the data returned must meet both of the parameters. To change the filter so that the data returned matches either filter “A” OR filter “B”, select the appropriate filter item in the Filter Fields list and choose the Or button. A good way to tell if the filter is going to return the data you expect is to read the filter statement to yourself to confirm that it makes sense before continuing.
- Enter the information you wish to filter on in the Value field in the following manner:
*Name of Field??[Value of field]. For example, “*Year Founded??2000” would return forms with the Field Name of “Year Founded” and an entry of 2000.
The criteria you enter will appear in the Filter Fields frame to the right of the window.
- The only form data in the Available Fields panel that you can filter on are the 10 keywords you assigned when creating the form.
- Click OK in the Add Filter Criteria dialog box to add the filter. The field is listed in the Filter Fields section in the top right corner of the wizard screen.
- Add any additional filters following the steps above.
- Once the fields, sort order, and filters have been properly set, click Next. The data is returned on Step 3 of the wizard.
Note: Select the Back button to go back one step in the Wizard if you make a mistake.
- Choose the desired output, and then click Next. The Post Query Options window opens.
- Select an option.