Home Privacy Policy Feedback Link to us Site Map Forums

Access: View SQL for a query in Access 2003/XP/2000/97


Also learn how to view SQL for a query in Access 2007.

Question:  In 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:


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