Number Field Size Property - lengthen a Number field

[Riveradan]

Hello,

I am trying to build a table that has a number field that needs to be 250
long.
I need this to perform calculations on so the results need to be viewable
and accurate.

Does anyone have either experience with this issue or have a work around for
it.

Thanks in advance for your help.

 

[Jeff Boyce]

I'm not sure I understand.

?You have a number (something you need to do math on) that can be 250 digits
long?! Have you checked Access HELP for "data types", looking up Long
Integer, Single, and Double types?

Good luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[John W. Vinson]

Hello,

I am trying to build a table that has a number field that needs to be 250
long.
I need this to perform calculations on so the results need to be viewable
and accurate.

Does anyone have either experience with this issue or have a work around for
it.

Thanks in advance for your help.

So you need to be able to (say) factor 250-digit numbers!? or multiply a 120
digit number by a 130 digit number? Ouch!

Access won't be able to do this. All of the flavors of Number fields wimp out
way before that level. You might want to look at MathCad or some other
specific mathematical program, or you'll be writing some very snarky VBA code
to handle Strings as numbers.


John W. Vinson [MVP]

 

[Jamie Collins]

I am trying to build a table that has a number field that needs to be 250
long.
I need this to perform calculations on so the results need to be viewable
and accurate.

The only Jet (and VBA) data type to support such large numbers is
DOUBLE FLOAT (Double) but it is only accurate to 15 significant
figures

Jamie.

--