[AccessD] Rounding. The collection.

Gustav Brock gustav at cactus.dk
Thu Apr 12 05:09:29 CDT 2018


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



More information about the AccessD mailing list