A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » General Discussion
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Select query not being saved



 
 
Thread Tools Display Modes
  #1  
Old January 26th, 2010, 03:54 AM posted to microsoft.public.access
MikeR
external usenet poster
 
Posts: 147
Default 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  
Old January 26th, 2010, 03:58 AM posted to microsoft.public.access
MikeR
external usenet poster
 
Posts: 147
Default 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  
Old January 26th, 2010, 03:14 PM posted to microsoft.public.access
John Spencer
external usenet poster
 
Posts: 7,815
Default 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  
Old January 26th, 2010, 03:38 PM posted to microsoft.public.access
Daryl S[_2_]
external usenet poster
 
Posts: 881
Default 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  
Old January 27th, 2010, 12:48 PM posted to microsoft.public.access
MikeR
external usenet poster
 
Posts: 147
Default 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  
Old January 27th, 2010, 12:53 PM posted to microsoft.public.access
MikeR
external usenet poster
 
Posts: 147
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 11:23 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.