fractions possible in ACCESS table?

[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!

 

[John Vinson]

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!

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!

 

[Bas Cost Budde]

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!

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.