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?
.