fractions possible in ACCESS table?

  • Thread starter Thread starter DZY
  • Start date Start date
D

DZY

How to input fractions such as 1/3, 2/5 in ACCESS tables?
There is such practical use in this format for slope,
velocity, etc. Of course you can input them as "text", but
can you input them as "number"?

Thanks!
 
The numeric datatype can be any of several "subtypes", including Decimal.
Single, Double, etc etc ... change the datatype to match the type of data
you're storing. Singles and Doubles allow the most precision.

--
Scott McDaniel
CS Computer Software
Visual Basic - Access - Sql Server - ASP

"Smash forehead on keyboard to continue ... "
 
How to input fractions such as 1/3, 2/5 in ACCESS tables?
There is such practical use in this format for slope,
velocity, etc. Of course you can input them as "text", but
can you input them as "number"?

Thanks!
Click to expand...

Only as .333333333333, .4 etc.; or by using VBA code in a Form to let
the user type in a fraction and have the computer evaluate it into a
number.

Alternatively you could use two textboxes, for numerator and
denominator, and store the quotient in a third field.

In any case a table datasheet will NOT be flexible enough for this
purpose!
 
DZY said:
How to input fractions such as 1/3, 2/5 in ACCESS tables?
There is such practical use in this format for slope,
velocity, etc. Of course you can input them as "text", but
can you input them as "number"?

Thanks!
Click to expand...

There is no Fraction data type. Would've been nice.

I think it is best to store both numerical parts separately (in an
Integer field). You can always divide them if you need the fractional
value (for arcsine, maybe?) but storing the fraction is never precise.
 
Back
Top