Prev: Date
Next: Export in cvs format
From: trip_to_tokyo on 5 Jun 2010 06:39
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.
From: Rick Brandt on 5 Jun 2010 14:19
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.

From: trip_to_tokyo on 5 Jun 2010 08:56
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.
>
> .
>
From: John W. Vinson on 5 Jun 2010 11:41
On Sat, 5 Jun 2010 03:39:06 -0700, trip_to_tokyo <info(a)pierrefondes.com>
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]
 | 
Pages: 1
Prev: Date
Next: Export in cvs format