To insert a value into your expression, you can select the value and click Insert Value , or double-click the value. The final step in defining a query is to add some optional finishing touches to your report. Finishing touches Sort the Data To make the results of your query more readable, you can sort by one or more of the columns in your database. Use the Sort Order dialog box in the Report Wizard to define the order in which you want to sort your columns. When you build your query, you can enter conditions and customize the rows of data retrieved.
Conditions are expressions used to reduce the number or rows that the query has to search.
As you customize the data to retrieve, you may want a column to match a specific value, you may want a column to be greater than a specific value, and so on. Add conditions to your query by clicking Add Condition in the Query Conditions dialog box in the Report Wizard. Use the Condition Builder to add conditions to your query. To access the Condition Builder, click Add Condition in the Query Conditions dialog box. The query that you build through the Report Wizard's user interface generates the SQL command that appears in the SQL Editor.