A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » New Users
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Does SQL Run Behind Queries?



 
 
Thread Tools Display Modes
  #1  
Old June 5th, 2010, 11:39 AM posted to microsoft.public.access.gettingstarted
trip_to_tokyo[_3_]
external usenet poster
 
Posts: 932
Default Does SQL Run Behind Queries?

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.
Ads
  #2  
Old June 5th, 2010, 01:56 PM posted to microsoft.public.access.gettingstarted
trip_to_tokyo[_3_]
external usenet poster
 
Posts: 932
Default Does SQL Run Behind Queries?

Rick, many thanks.

"Rick Brandt" wrote:

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.

.

  #3  
Old June 5th, 2010, 04:41 PM posted to microsoft.public.access.gettingstarted
John W. Vinson
external usenet poster
 
Posts: 18,261
Default Does SQL Run Behind Queries?

On Sat, 5 Jun 2010 03:39:06 -0700, 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.


The SQL *IS* the query.

The GUI is not the query; it's a tool that makes it easier to construct SQL.

You can view the query in the GUI or in SQL, toggle back and forth, look at
either one. You can't see the SQL "while the query is running" though, as far
as I know, if you mean in the same window.
--

John W. Vinson [MVP]
  #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.

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 01:31 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Copyright 2004-2017 OfficeFrustration.
The comments are property of their posters.