[AccessD] Numbers

This appears to work, mind you I didn't do much math on it:

<code>
Sub TestLong()
    Dim x As Double
    x = 34567899999999#
    Debug.Print x / 2
    Debug.Print Sqr(x)
End Sub
' returns  17283949999999.5 
' returns 5879447.25293109
</code>

Will that do, or is more testing required?

hth,
Arthur

----- Original Message ----
From: Martin Reid <mwp.reid at qub.ac.uk>
To: Access Developers discussion and problem solving <accessd at databaseadvisors.com>
Sent: Thursday, September 7, 2006 4:25:00 PM
Subject: [AccessD] Numbers

What would you dim the following number as in VBA
 
34567899999999
 
In order to carry out math on it.
 
Martin