S D
accessd667 at yahoo.com
Fri Apr 2 02:49:12 CST 2004
Bedankt :-) Bert Only problem is that the user's decided that they want this format for every date in the app. So I started changing stuff like you mentioned...Worked like a charm except 1 form. Here is the Rowsource dynamic. It is determined via a lot of selections. I'll have to figure this one out... Sander Bert-Jan Brinkhuis <thevigil at kabelfoon.nl> wrote: Hi Sander, i do not know what kind of nonsense that is, but i have a workaround for you. Add the original unformated [datum] field to your query and order on that field. Make sure you do not display that column in the combobox! HTH Bert-Jan ----- Original Message ----- From: "S D" To: "accessd" Sent: Friday, April 02, 2004 9:06 AM Subject: [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 > -- > _______________________________________________ > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com -- _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com --------------------------------- Do you Yahoo!? Yahoo! Small Business $15K Web Design Giveaway - Enter today