变量计算值 [英] Variable Calculated values
问题描述
嗨：
我需要为表单和报表上的计算值设置几个不同的公式。有没有办法将公式存储在字段中然后引用控件属性的控件源中的该字段？谢谢，
Patti
Hi:
I have a need to have several different formulas for a calculated value on a form and report. Is there a way to store the formula in a field then refer to that field in the control source of the control property? Thanks,
Patti
推荐答案
嗨：
我需要为表单和报表上的计算值设置几个不同的公式。有没有办法将公式存储在字段中然后引用控件属性的控件源中的该字段？谢谢，
Patti
Hi:
I have a need to have several different formulas for a calculated value on a form and report. Is there a way to store the formula in a field then refer to that field in the control source of the control property? Thanks,
Patti
如果我正确解释你，你必须明确地参考控制源中的公式/函数控件本身，而不是包含公式的字段。如果我可能会问，你想要完成什么？
If I interpret you correctly, you must explicitly refer to the Formula/Function in the Control Source of the Control itself, and not to a Field containing the Formula. What, if I may ask, are you trying to accomplish?
如果我正确地解释你，你必须明确地引用公式/控件源本身的功能，而不是包含公式的字段。如果我可能会问，你想要完成什么？
If I interpret you correctly, you must explicitly refer to the Formula/Function in the Control Source of the Control itself, and not to a Field containing the Formula. What, if I may ask, are you trying to accomplish?
我有一个表格，其中包含两个字段的计算值。这个公式适用于除表格中需要不同计算的一些项目之外的所有项目。在某些情况下，当前获得的结果需要进一步除以另一个数字。
I have a form with a calculated values that divides two fields. THis formula works for all but a few of the items in the form which requires a different calculation. In some cases the result that is currently obtained needs to further divided by another number.
我有一个包含计算值的表单两个领域。这个公式适用于除表格中需要不同计算的一些项目之外的所有项目。在某些情况下，当前获得的结果需要进一步除以另一个数字。
I have a form with a calculated values that divides two fields. THis formula works for all but a few of the items in the form which requires a different calculation. In some cases the result that is currently obtained needs to further divided by another number.
为什么不呢？
Why not?
- 在表单的基础记录源中创建一个计算字段。该字段将调用公共函数并将每个记录的字段值传递给它。在函数中，将分析字段，并将相应的结果传递回计算字段。
- 在表单的Current（）事件中应用类似的逻辑。
- 如果您需要进一步澄清，请告诉我。
这篇关于变量计算值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
