[AccessD] Replication and Referential Integrity

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