[AccessD] ORDER BY BUG using Date format AARHG

Bert-Jan Brinkhuis thevigil at kabelfoon.nl
Fri Apr 2 03:04:41 CST 2004


Graag gedaan :-) Sander

How is the rowsource dynamic? Do you make an sql string dynamically and make
that the rowsource?

Bert-Jan

----- Original Message ----- 
From: "S D" <accessd667 at yahoo.com>
To: "Access Developers discussion and problem solving"
<accessd at databaseadvisors.com>
Sent: Friday, April 02, 2004 10:49 AM
Subject: Re: [AccessD] ORDER BY BUG using Date format AARHG


> 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
> -- 
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com




More information about the AccessD mailing list