Format SQL Queries

[Ralf]

Hi,

I've quite long queries. Now after entering and formating those queries in a
readable format, as soon as I close and reopen the SQL View in MS Access, the
query is just one large string. Is there a way to keep the format?

Thank you,
Ralf

 

[Gina Whipp]

Ralf,

Nope (at least as far as I know), those SQL views will format the way they
like. The only ones I see keep the format I give them is Union queries.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

 

[John W. Vinson]

Hi,

I've quite long queries. Now after entering and formating those queries in a
readable format, as soon as I close and reopen the SQL View in MS Access, the
query is just one large string. Is there a way to keep the format?

Thank you,
Ralf

Alas, no, not in Access (despite years of groaning and grumbling).

All I can suggest is copying and pasting into an external text file after you
have it working.

 

[Tom van Stiphout]

On Tue, 17 Mar 2009 18:29:00 -0700, Ralf

All I can say is that this is an often-requested feature, and that
some people are trying hard to listen.
But in the current version: no, you're out of luck.

-Tom.
Microsoft Access MVP