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.
|