[AccessD] Replication and Referential Integrity

You will get scientification notation returned once the number
x exceeds 15 digits of  precision and truncation occurs.
Just try multiplying x by 100.

artful at rogers.com wrote:

>I am not having a problem with that either, Martin.
>
><code>
>Sub TestLong2()
>    Dim x As Double
>    Dim y As Integer
>    x = 34567899999999#
>    y = 10
>    Debug.Print x + 10
>    
>End Sub
>
>' returns  34567900000009  
></code>
>No scientific notation. For a moment I thought that the order of declaration or the order of summing might be the culprit, but apparently not:
>
><code>
>Sub TestLong3()
>    Dim y As Integer
>    Dim x As Double
>    x = 34567899999999#
>    y = 10
>    Debug.Print y + x
>    
>End Sub
>' returns  34567900000009  
> </code>
>
>I wonder whether any differences we are experiencing have to do with regional settings or something un-obvious like that. If this code is returning scientific notation, then I'm at a loss to explain why. One more detail. I ran this code in Access 2000.
>
>Arthur
>
>----- Original Message ----
>From: Martin Reid <mwp.reid at qub.ac.uk>
>To: Access Developers discussion and problem solving <accessd at databaseadvisors.com>
>Sent: Friday, September 8, 2006 4:07:36 AM
>Subject: Re: [AccessD] Replication and Referential Integrity
>
>Not bad Arthur.
> 
>What I am trying to get is the whole number returned. X+Y where X could be a massive number Y any number between 1 and 10. I had this problem for a while and anything I try ends up returning a number in scentification notation.
> 
> Martin WP Reid
>
>
>
>
>  
>

-- 
Marty Connelly
Victoria, B.C.
Canada