View Single Post
  #4  
Old June 5th, 2010, 07:19 PM posted to microsoft.public.access.gettingstarted
Rick Brandt
external usenet poster
 
Posts: 4,354
Default Does SQL Run Behind Queries?

trip_to_tokyo wrote:

Access 2007

When I run a query does Access, "go away" and run the SQL for what I see
in the GUI?

If the answer is, "yes" is there anything that I can switch on to see the
SQL that it is running?

What I would like to do, if it is possible, is to see the query in the GUI
and, at the same time, see the SQL that is being used to select the data
from the database; that way I can understand things (exactly what is
happening) more clearly and more quickly.

TIA for any replies.


Queries have three view options.

Datasheet
Design
SQL

There is no option to see the last two at the same time, but you can
certainly look at the SQL.