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
|
|||
|
|||
Select query not being saved
In Access 2000, if I build the following SQL, it runs (from the query builder) and
gives the expected results. When I save the query, Access deletes the ASC part. How can I have it saved? Thanks, Mike SELECT [UCALL], [Mode] FROM ModRef ORDER BY [mode] DESC , [ucall] ASC; |
#2
|
|||
|
|||
Select query not being saved
MikeR wrote:
In Access 2000, if I build the following SQL, it runs (from the query builder) and gives the expected results. When I save the query, Access deletes the ASC part. How can I have it saved? Thanks, Mike SELECT [UCALL], [Mode] FROM ModRef ORDER BY [mode] DESC , [ucall] ASC; Because ASC is the default? |
#3
|
|||
|
|||
Select query not being saved
That is the reason that Access removes it. I would like to see it retained if
it is entered, but that is very minor to the rest of what I would like Access to allow in the SQL view. WHINE WHINE WHINE I would like to be able to comment my SQL in line I would like Access to retain my formatting I would like Access to get rid of the non-standard way it handles sub-queries in the FROM clause WHINE OFF John Spencer Access MVP 2002-2005, 2007-2010 The Hilltop Institute University of Maryland Baltimore County MikeR wrote: MikeR wrote: In Access 2000, if I build the following SQL, it runs (from the query builder) and gives the expected results. When I save the query, Access deletes the ASC part. How can I have it saved? Thanks, Mike SELECT [UCALL], [Mode] FROM ModRef ORDER BY [mode] DESC , [ucall] ASC; Because ASC is the default? |
#4
|
|||
|
|||
Select query not being saved
Mike -
Yes, ascending is the default for ORDER BY, so it is not necessary in the statement. -- Daryl S "MikeR" wrote: MikeR wrote: In Access 2000, if I build the following SQL, it runs (from the query builder) and gives the expected results. When I save the query, Access deletes the ASC part. How can I have it saved? Thanks, Mike SELECT [UCALL], [Mode] FROM ModRef ORDER BY [mode] DESC , [ucall] ASC; Because ASC is the default? . |
#5
|
|||
|
|||
Select query not being saved
John Spencer wrote:
That is the reason that Access removes it. I would like to see it retained if it is entered, but that is very minor to the rest of what I would like Access to allow in the SQL view. WHINE WHINE WHINE I would like to be able to comment my SQL in line I would like Access to retain my formatting I would like Access to get rid of the non-standard way it handles sub-queries in the FROM clause WHINE OFF And a mighty fine whine it is! ;- |
#6
|
|||
|
|||
Select query not being saved
Daryl S wrote:
Mike - Yes, ascending is the default for ORDER BY, so it is not necessary in the statement. Thanks Daryl. rant on For documentation/clarity of intention purposes, it should be allowed. It's my query, and if it is syntactically correct, Access should *NOT* change it. rant off |
Thread Tools | |
Display Modes | |
|
|