[AccessD] DAO,VBA,A2K7?

...Access 2000 Charlotte ...and if you didn't know it was there, it's 
understandable why you'd not find much use for it :)
...like most things, it is of limited use except when you really need it 
...and then it should work correctly.
...but because it doesn't work correctly, I'm not using it either ...I'd 
like it in my toolbox.

William

----- Original Message ----- 
From: "Charlotte Foust" <cfoust at infostatsystems.com>
To: "Access Developers discussion and problem solving" 
<accessd at databaseadvisors.com>
Sent: Monday, June 19, 2006 11:53 AM
Subject: Re: [AccessD] DAO,VBA,A2K7?


> The Decimal type wasn't even legal in Access until what, A2003?  I've
> never seen much use for it in Access either, Gustav.
>
>
> Charlotte
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Gustav Brock
> Sent: Sunday, June 18, 2006 10:20 AM
> To: accessd at databaseadvisors.com
> Subject: Re: [AccessD] DAO,VBA,A2K7?
>
> Hi William
>
> Thanks. I realize now that I've never used the Decimal type for a field
> - Currency, Double or even Single have proven fine for the purposes.
> Now I know what to avoid.
>
> But one wonder how much it would take for the team to kill that bug. It
> can't (shouldn't) be much more than doing it.
>
> /gustav
>
>>>> wdhindman at dejpolsystems.com 18-06-2006 18:28 >>>
> 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
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>