Select query not being saved

Mike -

Yes, ascending is the default for ORDER BY, so it is not necessary in the
statement.
 >> Stay informed about: 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?
 >> Stay informed about: 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! ;->
 >> Stay informed about: 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>
 >> Stay informed about: Select query not being saved