Creating Queries for Records
You can create your own queries, execute them, and save them for later use. Queries that you create are called user-defined queries. In these queries, you can enter your own criteria to locate a specific set of records.
To create a query for records
Navigate to the screen.
Do one of the following:
In the list or form, click Query (the magnifying glass icon).
In the list or form, click Menu (the cogwheel icon), and then click New Query.
From the application-level menu, choose Query, then New Query.
From the application taskbar, click the New Query button.
Use the appropriate keyboard shortcut.
When you invoke the new query command, a blank form or a blank row in a list appears.
Enter the query criteria in the appropriate fields.
A wildcard is automatically assumed after text you enter in the query fields. If you search for
Siebe, then all words beginning with the lettersSiebeare found.If you query a data field that has a calendar select button to display the calendar control, then you must include the date field value in quotes. For more information about entering query criteria, see Simple Query Operators.
Do one of the following:
In the list or form, click Go.
In the list or form, click Menu (the cogwheel icon), and then click Run Query.
From the application-level menu, choose Query, and then Run Query.
From the application taskbar, click the Execute Query button.
Use the appropriate keyboard shortcut.
The query executes, and the records that match the query criteria appear.
To save the query, then do the following:
From the application-level menu, choose Query, then Save Query As.
The Save Query As dialog box appears.
In the Query Name field, enter a name for the query, and click OK.
The saved query appears in the drop-down list for the Saved Queries field.