How to view query design after executing without losing results?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I don't want to have to rerun a big query just because someone wants to check
out the design.

Simple question but the oracle of google doesn't answer intelligibly...
 
Open the Immediate window (Ctrl+G), and enter:
? CurrentDb.QueryDefs("Query1").SQL
substituting the name of your query for Query1.

You can then read the SQL statement, or paste it into a new query if you
want to see it graphically.

Of course, you can't alter the SQL without re-running the query.
 
Thanks for the reply. And how about if the person checking is my boss
(couldn't read sql to save his life :)
 
Copy the SQL statement from the Immediate Window (Ctrl+C.)
Open a new query.
Cancel the table dialog.
Switch to SQL View (left most toolbar icon, or View menu.)
Paste (Ctrl+V.)
Switch to Design view.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Queries, see new fields when table design has changed 2
EDIT SQL without going into design view first? 2
Queries losing fieldnames when importing from external mdb 2
Query Design Grid doesn't show. 4
ERROR 3125 when trying to enter design view of a query in 2007 6
Query won't open in design view 2
Using Design View versus SQL Statement View 11
Grouping by month and year in crosstab, without losing date value 2

Back
Top