MS Access 2007: View SQL for a query
This MSAccess tutorial explains how to view the SQL for a query in Access 2007 (with screenshots and step-by-step instructions).
See solution in other versions of Access:
Question: In Microsoft 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:
Advertisements