使用两个输入（excel函数）在文本框中生成计算值 [英] Generate calculated value in text box using two inputs (excel function)
问题描述
您好，
我目前正在将办公室的部分日常功能从单独的Excel电子表格切换到单个Access数据库。到目前为止，我已将此设置形式（合同）：
字段A：年度总使用量（kWh）
字段B：经纪费（ $ / kWh）
字段C：预期收入（字段A x字段B）
有什么方法可以让字段C自动计算A& B进入？表单链接到表。我在线阅读了一些不同的理论，但似乎并不简单，如果可能，我想在不手动运行查询的情况下完成。对不起，如果这是一个愚蠢的问题，我还在学习Access - 但这个网站已经帮助了很多！
任何帮助都将不胜感激！
Hello,
I am currently in the process of switching some of our daily functions at the office from separate excel spreadsheets into a single Access database. So far I have this setup in form ("Contracts"):
Field A: total annual usage (kWh)
Field B: broker fee ($/kWh)
Field C: Anticipated Revenue (field A x field B)
Is there any way to have Field C automatically calculate when A & B are entered? The form is linked to a table. I''ve read a few different theories online but nothing seems straightforward, and if at all possible I would like to do it without manually running a query. Sorry if its a stupid question, I''m still learning Access - but this site had helped out immensely!
Any help would be greatly appreciated!
推荐答案
/ kWh）
字段C：预期收入（字段A x字段B）
有没有办法让字段C自动计算何时A& B进入？表单链接到表。我在线阅读了一些不同的理论，但似乎并不简单，如果可能，我想在不手动运行查询的情况下完成。对不起，如果它是一个愚蠢的问题，我还在学习Access - 但这个网站已经帮助了很多！
任何帮助都将不胜感激！
/kWh)
Field C: Anticipated Revenue (field A x field B)
Is there any way to have Field C automatically calculate when A & B are entered? The form is linked to a table. I''ve read a few different theories online but nothing seems straightforward, and if at all possible I would like to do it without manually running a query. Sorry if its a stupid question, I''m still learning Access - but this site had helped out immensely!
Any help would be greatly appreciated!
将字段c'的控制源设置为：
= [fielda] * [fieldb]
set field c''s control source to:
=[fielda]*[fieldb]
哇，非常感谢你！不能相信它就是那么简单......就像一个魅力！再次感谢！
Wow thank you so much! Can''t believe it was that simple...worked like a charm! Thanks Again!
这篇关于使用两个输入（excel函数）在文本框中生成计算值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
