VB equivalent of foxpro numeric field (Code and Table)

[InstructionWhich7142]

[FONT=&quot]I am using Access 2007 and VB to work on data from a Visual FoxPro 6 production management system, using ODBC

so far I have not had many problems with numbers (at least not that we have noticed)

How ever I have started working in some new areas where a lot of values are decimal, so using the VB Long(Integer) data type is obviously causing issues,

Most values in the system is stored in the FoxPro Numeric format:[/FONT]
[FONT=&quot]Numeric [/FONT]

[FONT=&quot]Integers or decimal numbers[/FONT]
[FONT=&quot]For example, the quantity of items ordered[/FONT]

[FONT=&quot]8 bytes in memory; 1 to 20 bytes in table[/FONT]
[FONT=&quot]- .9999999999E+19 to .9999999999E+20[/FONT]

[FONT=&quot]http://msdn.microsoft.com/en-us/library/ww305zh2%28v=vs.80%29.aspx

I notice in the system this is locked to 4 DP and 12 characters total, does this solve the rounding issue of floating point numbers explained here? : http://support.microsoft.com/kb/214118
which I have only just discovered (and am a bit worried about!)?[/FONT]


[FONT=&quot]Also what would be the best equivalent in VB to store and work on these values? Double?[/FONT]
[FONT=&quot]
[/FONT]
[FONT=&quot]Thanks,
[/FONT]