switch the way the query opens from a design view to an SQL view

is there an option to switch the way the query opens from a design
view to an SQL view without entering to the query befoere?

Re: switch the way the query opens from a design view to an SQL view

thread wrote:
> is there an option to switch the way the query opens from a design
> view to an SQL view without entering to the query befoere?

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

No. If you want the query to open in SQL view you'll have to save it
while that view is on screen. If you want to just see the SQL string
w/o opening the query you can do the following:

In the Debug window (Ctrl-G) type something like the following:

? currentdb.querydefs("qrySales").sql

It will display the sql string of the query "qrySales."

HTH,
--
MGFoster:::mgf00 earthlink net
Oakland, CA (USA)
** Respond only to this newsgroup. I DO NOT respond to emails **

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBR/6RGoechKqOuFEgEQKrKgCg0A5+X5eOC5s+1kdKKk7+3V/gHwEA n06t
fdtJrvLwUv8p5sX8EkhC3KRH
=jnVY
-----END PGP SIGNATURE-----