[AccessD] DAO,VBA,A2K7?

Gustav

...SELECT MyField FROM MyTable ORDER BY MyField DESC;

...make MyField a Decimal type ...enter test data including negatives, 
positives, nulls, and zeros and sort in descending order ...in A2K and later 
negative values will appear first followed by the positive ones ...nulls and 
zeros sort unpredictably, at the beginning, middle or end, depending on the 
data.

...note that Allen Brown has a sample mdb demonstrating this on his site.

William

----- Original Message ----- 
From: "Gustav Brock" <Gustav at cactus.dk>
To: <accessd at databaseadvisors.com>
Sent: Sunday, June 18, 2006 12:12 PM
Subject: Re: [AccessD] DAO,VBA,A2K7?


> Hi William
>
> I've never seen this. How can you demonstrate that?
>
> /gustav
>
>>>> wdhindman at dejpolsystems.com 18-06-2006 17:13 >>>
> 6) decimal fields sort incorrectly
>
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>