Arithmatic&查找列 - 奇怪的东西 [英] Arithmatic & lookup columns - weird stuff
问题描述
说明字段从另一个表中查找值：说明，
ProductCost，DeliverCost，OtherCost& SalePrice。
AfterUpdate描述字段为：
Me！Cost =
Me！Description.Column（1）+我！描述.Column（2）+ Me！Description.Column（3）
Me！Price = Me！Description.Column（2）
这个应该添加ProductCost，DeliverCost& OtherCost并将其输入
到Cost字段中。所有三个Cost列（Product，
Delivery& Other）中都有一个值，无论是数字还是0，都没有空值。在一些
项目上它完美运行，在其他项目上似乎将数字乘以100
（即产品成本= 24.00美元，交付= 0，其他= 0，成本变为$ 2400.00），
和其他人我收到错误（运行时间2113 - 您输入的值不是
对此字段有效）
测试一些数据后，看起来：
如果ProductCost（Description.Column（1））是一整元，那么金额是
乘以100，但如果金额有美分则不是。
如果ProductCost不是一个整数金额并且有一个非零金额
in column2（DeliveryCost）我收到错误消息
有任何想法
The description field looks up values from another table: Description,
ProductCost, DeliverCost, OtherCost & SalePrice.
AfterUpdate of the description field is:
Me!Cost =
Me!Description.Column(1)+Me!Description.Column(2)+ Me!Description.Column (3)
Me!Price = Me!Description.Column(2)
This is supposed to add ProductCost, DeliverCost & OtherCost and input it
into a Cost field. There is a value in all three Cost columns (Product,
Delivery & Other) whether it be a figure or 0, there are no nulls. On some
items it works perfectly, on others it seems to multiply the number by 100
(i.e. Product cost = $24.00, Deliver = 0, Other = 0, Cost becomes $2400.00),
and on others I get an error (Runtime 2113 - The value you entered isn''t
valid for this field)
Upon testing some of the data, it appears that:
If ProductCost (Description.Column(1)) is a whole dollar then the amount is
multiplied by 100 but if the amount has cents it is not.
If ProductCost is not a whole dollar amount and there is a non-zero amount
in column2 (DeliveryCost) I get the error message
Any thoughts
推荐答案
24.00， Deliver = 0，Other = 0，Cost变为
24.00, Deliver = 0, Other = 0, Cost becomes
2400.00），
和其他人我得到一个错误（运行时2113 - 您输入的值不是'' t
对此字段有效）
Upo n测试一些数据，看来：
如果ProductCost（Description.Column（1））是一整元，那么金额是
乘以100，但如果金额有美分则不是。
如果ProductCost不是一个整数金额并且第二列中存在非零金额
（DeliveryCost）我收到错误消息
有任何想法
2400.00),
and on others I get an error (Runtime 2113 - The value you entered isn''t
valid for this field)
Upon testing some of the data, it appears that:
If ProductCost (Description.Column(1)) is a whole dollar then the amount is
multiplied by 100 but if the amount has cents it is not.
If ProductCost is not a whole dollar amount and there is a non-zero amount
in column2 (DeliveryCost) I get the error message
Any thoughts
您的所有字段都填充了查找列的货币吗？例如
所有的数据类型都一样吗？你有没有设置你正在计算的
字段的数据类型？
Are all of your fields that populate the lookup columns currency? Eg
are all the Data Type''s the same? And have you set the data type of the
field you are calculating?
这篇关于Arithmatic&查找列 - 奇怪的东西的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
