[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