Access: View SQL for a query in Access 2007

Also learn how to view SQL for a query in Access 2003/XP/2000/97.

Question:  In Access 2007, I've created a query and I want to view the SQL for this query. How do I do this?

Answer: First, you need to open the query in Design View. To do this, right-click on the Query in the left window and select Design View from the popup menu.

Next, select the Design tab in the toolbar at the top of the screen. Then click on the View button in the Results group. Select SQL View from the popup menu.

The SQL should now be displayed for the Query as follows: