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;