[AccessD] Rounding. The collection.

[Jim Lawrence]

You never fail to amaze me. :-)

Jim

----- Original Message -----
From: "Gustav Brock" <gustav at cactus.dk>
To: "Access Developers discussion and problem solving" <accessd at databaseadvisors.com>
Sent: Thursday, April 12, 2018 3:09:29 AM
Subject: Re: [AccessD] Rounding. The collection.

Hi all

Recently, I've supplemented this with rounding of a sum and rounding with the power of two:

    Round elements of a sum to match a total
    https://www.experts-exchange.com/articles/31683/Round-elements-of-a-sum-to-match-a-total.html

    Round by the power of two
    https://www.experts-exchange.com/articles/31859/Round-by-the-power-of-two.html

Both operates with Decimal for extreme precision for "normal" numbers and with Double for very large or small numbers.

/gustav

-----Oprindelig meddelelse-----
Fra: AccessD [mailto:accessd-bounces at databaseadvisors.com] På vegne af Gustav Brock
Sendt: 31. august 2015 22:33
Til: Access Developers discussion and problem solving <accessd at databaseadvisors.com>
Emne: [AccessD] Rounding. The collection.

Hi all

After many years I've managed to collect and polish the rounding functions I have for VBA and posted these at Experts Exchange:

"Rounding values up, down, by 4/5, or to significant figures"

    http://rdsrc.us/4phszx

The challenge is to handle both the very large and very small numbers of Double, floating point errors, and the large values and large count of decimals for Decimal - as well as symmetrical/asymmetrical rounding up/down of positive/negative values.

/gustav

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com