If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Fraction number in Access
Is anybody can tell me, if MS Access can accept fraction number like Excel?.
I had a project before, the user had to enter with fraction number. I still can't figure it out untul now. KF -- Message posted via http://www.accessmonster.com |
#2
|
|||
|
|||
Fraction number in Access
That depends... do you want Access to merely "accept" a string of
characters, or will you be wanting to "do math" on the value that string of characters represents? If the latter, one way to do this would be to build a function that takes a "text" input (e.g., "1/5") and converts it to a decimal equivalent. Access can "do math" on the decimal equivalent. Regards Jeff Boyce Microsoft Office/Access MVP "KimTong via AccessMonster.com" u35279@uwe wrote in message news:7778e1f04ca68@uwe... Is anybody can tell me, if MS Access can accept fraction number like Excel?. I had a project before, the user had to enter with fraction number. I still can't figure it out untul now. KF -- Message posted via http://www.accessmonster.com |
#3
|
|||
|
|||
Fraction number in Access
I don't mind wheter Access accept in Text or Number, as long as Acces can do
calculation. So when the user enter the price, that price should be in fraction. Then Access has to convert it in decimal or whatever, so we can calculate that field when we need it. Thanks for your help. KF KimTong wrote: Is anybody can tell me, if MS Access can accept fraction number like Excel?. I had a project before, the user had to enter with fraction number. I still can't figure it out untul now. KF -- Message posted via http://www.accessmonster.com |
#4
|
|||
|
|||
Fraction number in Access
How to convert from "1/5" to 0.20 (in decimal)?
THanks... KF Jeff Boyce wrote: That depends... do you want Access to merely "accept" a string of characters, or will you be wanting to "do math" on the value that string of characters represents? If the latter, one way to do this would be to build a function that takes a "text" input (e.g., "1/5") and converts it to a decimal equivalent. Access can "do math" on the decimal equivalent. Regards Jeff Boyce Microsoft Office/Access MVP Is anybody can tell me, if MS Access can accept fraction number like Excel?. [quoted text clipped - 3 lines] KF -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...forms/200708/1 |
#5
|
|||
|
|||
Fraction number in Access
Take a look at the Eval() function. I believe you can use
Eval("1/5") to get 0.2 You could do that calculation in a form, allowing the user to enter "1/5" in an unbound textbox, then doing the math to get 0.2 and storing that via a bound textbox (it could even be hidden). Regards Jeff Boyce Microsoft Office/Access MVP "KimTong via AccessMonster.com" u35279@uwe wrote in message news:77853d9876d29@uwe... How to convert from "1/5" to 0.20 (in decimal)? THanks... KF Jeff Boyce wrote: That depends... do you want Access to merely "accept" a string of characters, or will you be wanting to "do math" on the value that string of characters represents? If the latter, one way to do this would be to build a function that takes a "text" input (e.g., "1/5") and converts it to a decimal equivalent. Access can "do math" on the decimal equivalent. Regards Jeff Boyce Microsoft Office/Access MVP Is anybody can tell me, if MS Access can accept fraction number like Excel?. [quoted text clipped - 3 lines] KF -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...forms/200708/1 |
Thread Tools | |
Display Modes | |
|
|