关于访问的问题 [英] Question about Access
问题描述
我有一个关于Access的问题:
我有Access文件框和组合框的组合。
我想计算一些东西以这种形式。
我想计算Total_Dose / Total Volume并将结果放在Final_Dose中(请注意这些所有文本框)。公式正在运行,这不是问题。
如果我除以100/50,我将得到2并且它将保存在MainTable中。
但是现在如果我除以50/100,我将得到0.5,我想将此值(0.5)更改为50.这就是我遇到问题的地方。我们有办法解决这个问题吗?
以下是此代码,请看一下,请帮帮我。
Private Sub Total_Dose_Change( )
Me.Final_Dose =(Me.Total_Dose / Me.Total_Volume)
End Sub
Private Sub Total_Dose_LostFocus()
Me.Final_Dose =(Me.Total_Dose / Me.Total_Volume)
End Sub
Private Sub Total_Volume_Change()
Me.Final_Dose =(Me.Total_Dose / Me.Total_Volume)
End Sub
Private Sub Total_Volume_LostFocus()
Me.Final_Dose =(Me.Total_Dose / Me.Total_Volume)
End Sub
I have a questin about Access:
I have Access form with a combination of text box and combo boxes.
I want to calculate some thing in this form.
I want to calculate Total_Dose / Total Volume and put the result in the Final_Dose (mind you these r all text boxes). The formula is working, thats not a problem.
If i divide 100/50, i will get 2 and it will save in the MainTable.
but now If i divide 50/100, i will get 0.5, i want to change this value (0.5) to 50., thats where i am having problem. Is there a way we can fix this?
Below is the code for this, please take a look, and help me out please.
Private Sub Total_Dose_Change()
Me.Final_Dose = (Me.Total_Dose / Me.Total_Volume)
End Sub
Private Sub Total_Dose_LostFocus()
Me.Final_Dose = (Me.Total_Dose / Me.Total_Volume)
End Sub
Private Sub Total_Volume_Change()
Me.Final_Dose = (Me.Total_Dose / Me.Total_Volume)
End Sub
Private Sub Total_Volume_LostFocus()
Me.Final_Dose = (Me.Total_Dose / Me.Total_Volume)
End Sub
推荐答案
我有一个关于访问的问题:
我有一个包含文本框和组合框的Access表单。
我想以这种形式计算一些东西。
我想计算Total_Dose / Total Volume并将结果放入t他Final_Dose(请注意这些所有文本框)。公式正在运行,这不是问题。
如果我除以100/50,我将得到2并且它将保存在MainTable中。
但是现在如果我除以50/100,我将得到0.5,我想将此值(0.5)更改为50.这就是我遇到问题的地方。我们有办法解决这个问题吗?
以下是此代码,请看一下,请帮帮我。
Private Sub Total_Dose_Change( )
Me.Final_Dose =(Me.Total_Dose / Me.Total_Volume)
End Sub
Private Sub Total_Dose_LostFocus()
Me.Final_Dose =(Me.Total_Dose / Me.Total_Volume)
End Sub
Private Sub Total_Volume_Change()
Me.Final_Dose =(Me.Total_Dose / Me.Total_Volume)
End Sub
Private Sub Total_Volume_LostFocus()
Me.Final_Dose =(Me.Total_Dose / Me.Total_Volume)
End Sub
我需要帮助...任何请问???
please I need help...any body please???
从0.5到50转换为什么规则?
当结果小于时,你总是想乘以100吗? 1?
What rules do you have for converting from 0.5 to 50?
Do you always want to multiply by 100 when your result is less than 1?
您有什么规则可以将0.5转换为5 0?
当你的结果小于1时,你总是想乘以100吗?
What rules do you have for converting from 0.5 to 50?
Do you always want to multiply by 100 when your result is less than 1?
你是怎么做到的?它是如果ELSE声明?请你帮帮我吗?
谢谢
and how do you do that? is it IF ELSE statements? would u please help me out in this?
thanks
这篇关于关于访问的问题的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!