By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
444,153 Members | 2,581 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 444,153 IT Pros & Developers. It's quick & easy.

How to enter data in form of 1/2

P: n/a
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.
Dec 6 '07 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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.
Dec 6 '07 #2

P: n/a
On Thu, 6 Dec 2007 09:45:51 -0800 (PST), Abedin <ab*****@gmail.com>
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.
Dec 7 '07 #3

This discussion thread is closed

Replies have been disabled for this discussion.