Constructing an SQL SELECT Command

To construct an SQL SELECT command using the SQL Wizard:

1. From the Record Source tab of the Data Control OLE Properties dialog box, click Run SQL Wizard. The Select Operation dialog box appears.
2. In the Select Operation dialog box, click SQL Select. The Select Tables dialog box appears.
3. Select one or more tables for your statement, then click Next. The Select Columns dialog box appears.
4. Select one or more table columns for your statement.
5. Optionally, select the Return Unique Rows check box, then click Next. The Create Row Filter dialog box appears.
6. Optionally, create a row filter based on selection criteria you define. Click Next. The Select Columns to Sort By dialog box appears.
7. Optionally, sort the data in ascending or descending order by column values. Click Next. The Finish dialog box appears.
8. Optionally, edit the statement. Click OK to return to the Data Control OLE Properties dialog box.

See Also