[AccessD] Math in VBA

> decimal point (and four to the left).

Should be four to the right

Reuben Cummings
GFC, LLC
812.523.1017


> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Reuben
> Cummings
> Sent: Thursday, July 19, 2007 11:24 AM
> To: Access Developers discussion and problem solving
> Subject: Re: [AccessD] Math in VBA
>
>
> Currency data types would be perfect if you are concerned about
> the accuracy
> of the decimals.  However, it only handles 15 digits to the left of the
> decimal point (and four to the left).
>
> Single can be used well, but you will have to be careful how you handle
> rounding.  I have to use single in several cases and then test, test, test
> to determine in what order, when, and where I should perform any rounding.
>
> Reuben Cummings
> GFC, LLC
> 812.523.1017
>
>
> > -----Original Message-----
> > From: accessd-bounces at databaseadvisors.com
> > [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Mark A Matte
> > Sent: Thursday, July 19, 2007 11:11 AM
> > To: accessd at databaseadvisors.com
> > Subject: [AccessD] Math in VBA
> >
> >
> > Hello All,
> >
> > This is just a 'mild' form of encryption...but I need to use
> > math(+-*/) with
> > numbers up to 16 digits(9,999,999,999,999,999)...
> >
> > Is there any way to do this without losing accuracy in VBA?
> >
> > Thanks,
> >
> > Mark A. Matte
> >
> > _________________________________________________________________
> > Don't get caught with egg on your face. Play Chicktionary!
> > http://club.live.com/chicktionary.aspx?icid=chick_hotmailtextlink2
> >
> >
>
>
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>