在表字段中存储字段值 Access 2010
我有一个问题，我在表格上进行了一个简单的计算 =[subtotal]-[discount]+[delivery]
然后我想将结果存储在我的订单表中的 TotalPrice 字段下 我在谷歌上搜索过，但找不到任何对我有帮助的东西。
我知道将字段值存储在表中不好，但需要这样做。
提前致谢。
只是要明确一点。 [小计] [折扣] 和 [送货] 都是表单上的文本框。然后有一个名为 [Total] 的框，出现在名为 [total] 的文本框中，这就是我想要将该字段存储在我的订单表中的内容。
I have a problem I have a simple calculation carried out on a form
=[subtotal]-[discount]+[delivery]
I then want to store the result in my order table under the field TotalPrice
I have hunted around google but can not find anything that helps me.
I know its not good to store field values in tables but it needs to be done.
Thanks in advance.
Just to be clear.
[subtotal] [discount] and [delivery] are all text boxes on a form. there is then a box called [Total] what appears in the textbox called [total] is what I want to then store the field in my order table.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
最好创建一个查询，然后让需要计算值的任何人/任何东西使用查询而不是直接使用表。
但是，您可以在表单上创建一个触发器（例如 OnCurrent 事件），然后让该触发器执行以下操作。
但是，每当您更改记录时，都会触发该操作。首先检查它是否已设置可能会稍微好一些
，但是如果其组件值被重置，您的值不会更新。在这种情况下，您也可以在这些字段上放置触发器（也许是 AfterUpdate 事件）。
或者
您可以检查每次的值是否不同。
（对于实数可能无法正常工作，但对于货币可能无法正常工作）
当然，这一切都假设 txtCalcField 组件更新的唯一方式是通过表单 - 永远。
这都是狗的早餐 - 在这种情况下，我引导您回到我的第一个陈述 - 使用查询。
It would be better to create a query, and then have whomever/whatever needs that calculated value use the query instead of the table directly.
HOWEVER, you could create a trigger on the form on something like the OnCurrent event, and then have that trigger execute the following.
However, that would fire any time you changed records. It might be slightly better to check if it's set first
But then if its components values get reset, your value doesn't get updated. In which case, you could put triggers on those fields as well (AfterUpdate events perhaps).
OR
You could check the value's aren't different each time.
(which probably won't work properly with Reals, but might with Currency)
Of course, that's all assuming the only way the components of txtCalcField will be updated is through the form - forever.
It's all a dog's breakfast - in which case, I direct you back to my first statement - use a query.