存储计算值 [英] Storing calculated values

问题描述

Hello Folks，


我正在整理一个数据库并试图总结当天产生的废钢总量，我有一份报告可以完成这项任务。


但是在我得到报告中的总废料后我希望它存储在我的表中，bcoz我将需要这些信息来制作内部和外部汇集的其他报告废料。我在表格和表格中都有总废料列，当我尝试设置此字段的控件来源属性时，它会弹出NAME？，您能否建议我在哪里找不到链接？


我们提前感谢您的帮助。

解决方案

您要将控制源设置为什么？

< blockquote>我将控制源设置为= [Reports]！[Bedplate]！[GrandTotal]

此外，我的DB已经开始表现得很有趣了。


我正在尝试为内部废料％和外部废料％设置控制源属性，它工作得很好但唯一的问题是它在表中没有正确保存，例如我在表单上获得内部废料％4.51，但它在表格中保存为500％。


我将表单的文本框废料％控制属性更改为：

格式=％

十进制=自动

我将表格中内部废料％的字段属性更改为：

字段大小=双倍

格式=％

十进制=自动


谢谢

Hello Folks,

I am putting together a DB and trying to sum up the total scrap produced in house for the day, i have a report which accomplishes this task for me.

But after i get the total scrap in the report i want it to be stored in my table aswell, bcoz i will need this information to make the other report which brings together internal and external scrap. I have the total scrap column in the table and the form aswell, and when i try to set the control source property of this field it pops up with NAME?, can you please suggest me where i am missing a link?

Your help is appreciated in advance.

解决方案

What are you setting the control source to?

I am setting the control source as =[Reports]![Bedplate]![GrandTotal]

Also, my DB has started behaving v funny.

I am trying to set the control source property for the internal scrap % and external scrap %, it works wonderful but the only problem is it doesnt save properly in the table, for e.g. i get internal scrap % as 4.51 on the form but it saves as 500 % in the table.

I changed the textbox scrap % control properties for the form as:
Format = %
Decimal = Auto

I changed the field properties for the internal scrap % in the table as:
field size= double
format= %
decimal = auto

Thanks

这篇关于存储计算值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！