How to enter data in form of 1/2

Hello all,

I am having problem in entering data in the form of

1/2
1/22
1/3
3/33
2/44

Thank you.

Re: How to enter data in form of 1/2

Abedin wrote:
> Hello all,
>
> I am having problem in entering data in the form of
>
> 1/2
> 1/22
> 1/3
> 3/33
> 2/44
>
> Thank you.

You could create a table with 3 fields; Whole Number, Numerator and
Denominator. Then have 2 fields to enter the fractional parts with the
/ sign between them.

Otherwise you could make the field text to enter whatever you like.
That would work if you don't need to find decimal equivalents and you
don't need much error checking.

A long time ago I had a table with the fractional value (1/2) and the
decimal value (.5). So if the number was decimal or fractional I could
find the respective value I wanted.

Re: How to enter data in form of 1/2

On Thu, 6 Dec 2007 09:45:51 -0800 (PST), Abedin
wrote:

I'm not sure what exactly you are trying to accomplish. Assuming you
want the value, not the exact notation, there is an elegant solution
using the Eval function:
Eval("1/2") = 0.5
In a sense Eval works like a calculator does.
Then store that value in a field of type Numeric - Single.

-Tom.



>Hello all,
>
>I am having problem in entering data in the form of
>
>1/2
>1/22
>1/3
>3/33
>2/44
>
>Thank you.