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. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
newbie SQL question
i'm working at learning how to design queries using SQL. Based on what I've
seen in this group, the SQL is much easier to follow and understand when properly aligned (for example, with a subquery's Select, From, Where, and OrderBy all lined up vertically) I know that Access ignores spaces and new lines in SQL statements, but I'd like to be able to reopen the query window without the formatting being changed. Is there a solution? (it would also make it easier for pasting SQL to this newsgroup) |
#2
|
|||
|
|||
newbie SQL question
This makes it easier:
http://www.wangz.net/cgi-bin/pp/gsql.../sqlformat.tpl Cheers, Jason Lepack On Feb 26, 5:49 pm, Victoria wrote: i'm working at learning how to design queries using SQL. Based on what I've seen in this group, the SQL is much easier to follow and understand when properly aligned (for example, with a subquery's Select, From, Where, and OrderBy all lined up vertically) I know that Access ignores spaces and new lines in SQL statements, but I'd like to be able to reopen the query window without the formatting being changed. Is there a solution? (it would also make it easier for pasting SQL to this newsgroup) |
#3
|
|||
|
|||
newbie SQL question
wow - great reference. Thank you!
"Jason Lepack" wrote: This makes it easier: http://www.wangz.net/cgi-bin/pp/gsql.../sqlformat.tpl Cheers, Jason Lepack On Feb 26, 5:49 pm, Victoria wrote: i'm working at learning how to design queries using SQL. Based on what I've seen in this group, the SQL is much easier to follow and understand when properly aligned (for example, with a subquery's Select, From, Where, and OrderBy all lined up vertically) I know that Access ignores spaces and new lines in SQL statements, but I'd like to be able to reopen the query window without the formatting being changed. Is there a solution? (it would also make it easier for pasting SQL to this newsgroup) |
Thread Tools | |
Display Modes | |
|
|