[AccessD] Hooking into APIs of supplemental vendors

In Access, the other option is Currency.   Which is an 8 byte scaled integer

-- 
Stuart

On 9 Jul 2013 at 14:33, Gustav Brock wrote:

> Hi Jim
> 
> I've found that in the cases where you need a "Double of a Double", the
> subdatatype of Variant, Decimal, would do.

> To create a Decimal, you need CDec:
> 
>   Dim varDecimal As Variant
>   varDecimal = CDec(<SomeDecimalNumber>)
> 
> /gustav
> 
> -----Oprindelig meddelelse-----
> Fra: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] På vegne af James Button
> Sendt: 9. juli 2013 09:24
> Til: Access Developers discussion and problem solving
> Emne: Re: [AccessD] Hooking into APIs of supplemental vendors
> 
> Hi,
> 
> A word of warning -
> 
> I worked on an investment banking system with inbuilt currency conversion,
> and had to rewrite a module to use the equivalent of 'doubles' because some
> currencies hit 9 places to the £ that means that a simple conversion to/from
> £ needed 18 places of accuracy
> 
> Not useing that accuracy may not be a practical concern for the investor,
> but it sure can make it impossible to balance the accounts.
> £100,000.00 invested at 200,000,000,000 to the £ and then 'sold' at - say
> 185,500,000,000
> 
> JimB
> 
> 
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>