Correct: AFAIK, this bug has never been fixed, despite the fact that it is
now more than 5 years old.
It's pretty embarrassing that Access gets such an incredibly simple query
wrong.
It's even more embarassing that Microsoft doesn't care enough about Access
to fix such a basic flaw.
--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users -
http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
<ha*****@bezeqint.net> wrote in message
news:11**********************@g44g2000cwa.googlegr oups.com...
Hello.
I read the Microsoft article about the sorting of negative deciaml
values (http://support.microsoft.com/?id=837148), however, the problem
wasn't solved.
It works fine when I use a simple query:
SELECT Costs
FROM MyTable
ORDER BY Costs DESC
But when I add a criteria to the query, the results are in the wrong
order again:
SELECT Costs
FROM MyTable
WHERE [Quarter]=1
ORDER BY Costs DESC
Any suggestions?
Thanks