Number Field Size Property - lengthen a Number field

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 
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.
Click to expand...

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]
 
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.
Click to expand...

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.

--
 
Back
Top