totn Access

MS Access 2003: View SQL for a query

This MSAccess tutorial explains how to view the SQL for a query in Access 2003 (with screenshots and step-by-step instructions).

Question: In Microsoft Access 2003/XP/2000/97, I've created a query and I want to view the SQL for this query. How do I do this?

Answer: To view the SQL for a query, open your query in design view.

Then under the "View" menu, select "SQL View" OR you can select "SQL View" from the toolbar as seen in the picture below:

Microsoft Access

Your Query window should now display the SQL for the query. See below:

Microsoft Access