MS Access: View SQL for a query in Access 2003/XP/2000/97
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:
Your Query window should now display the SQL for the query. See below: