Creating a query involves several steps: selecting the record type, adding filters, creating the display layout, and saving and running the query.
To create a query:
The query is saved to the folder you specified on the first page of the New Query wizard. When you run a query, the results appear in the Query Results view. You can change the sort order of the query results by clicking the heading at the top of each column.
The administrator usually sets a soft limit on the number of rows that can be displayed in a resultset when you run a query. If the query that you run tries to return a recordset that is greater than this limit, a dialog is displayed letting you know that the limit has been exceeded. In this dialog, you can edit the limit and make it higher.