[AccessD] ORDER BY BUG using Date format AARHG

Hi group,
 
I've got a combobox based on a query:
SELECT DISTINCT [TblArbo].[Datum]
FROM TblArbo
ORDER BY [TblArbo].[Datum] DESC;
Resulted in:
01-10-2003
02-09-2003
21-08-2001
 
The user asked if this could be printed in the following format: dd-mmm-yyyy
No problem, says stupid me:
SELECT DISTINCT Format([TblArbo].[Datum],"dd-mmm-yyyy")
FROM TblArbo
ORDER BY Format([TblArbo].[Datum],"dd-mmm-yyyy") DESC;
 
But now the ORDER BY ONLY checks the DD part?!?!?!?!
So this results in:
21-08-2001

02-09-2003
01-10-2003
?!!??! What kind of nonsense is this?
 
Sander


---------------------------------
Do you Yahoo!?
Yahoo! Small Business $15K Web Design Giveaway - Enter today