View or modify the SQL statement behind an existing query

If you're familiar with SQL, you may want to work directly with a query's underlying SQL statement.

1. Create a query or open an existing query.
   
   
2. Click the arrow next to View on the toolbar, and then click SQL View.

   Microsoft Access displays the SQL statement that is equivalent to what you created in Design view.

3. If you want to make changes, type your changes in the SQL statement.
   
   
4. To see the changes in the design grid, click the arrow next to the View button on the toolbar, and then click Design View.