以另一个为条件制作场地 [英] making a feild conditional upon another

问题描述

我希望feild total显示一个项目的总成本，如果该项目有增值税是，则在场地增值税中没有框，我有没有增值税的项目的价格。我希望feild total显示[price] *增值税率，如果增加了一个增值税盒并且我希望它显示[价格]如果没有勾选增值税盒但是我不知道该做什么帮助？

I want the feild total to display the total cost of an item, If the item has vat a yes no box is ticked in the field vat and I have the price of the item without vat. I want the feild total to display [price]*vat rate if the vat box is ticked and I want it to display the [price] if the vat box is not ticked but i''m at a loss as to what to do any help?

推荐答案

我希望feild total显示一个项目的总成本，如果该项目有增值税是的没有框在现场增值税中勾选，我有没有增值税的项目的价格。我希望feild total显示[price] *增值税率，如果增加了一个增值税盒并且我希望它显示[价格]如果没有勾选增值税盒但是我不知道该做什么救命？

I want the feild total to display the total cost of an item, If the item has vat a yes no box is ticked in the field vat and I have the price of the item without vat. I want the feild total to display [price]*vat rate if the vat box is ticked and I want it to display the [price] if the vat box is not ticked but i''m at a loss as to what to do any help?

是否要使用表单执行此操作或默认表中新记录的值。对于现有记录，您必须运行更新查询。


告诉我，我会提供说明。

Do you want to do this using a form or to default the value for new records in a table. For existing records you will have to run an update query.

Let me know and I''ll provide instructions.

是否要使用表单执行此操作或默认表中新记录的值。对于现有记录，您必须运行更新查询。


告诉我，我会提供说明。

Do you want to do this using a form or to default the value for new records in a table. For existing records you will have to run an update query.

Let me know and I''ll provide instructions.

理查德不要发送PM对帖子的回复

Richard don''t send me PM''s reply to the post

是否要使用表单执行此操作或默认表中新记录的值。对于现有记录，您必须运行更新查询。


告诉我，我会提供说明。

Do you want to do this using a form or to default the value for new records in a table. For existing records you will have to run an update query.

Let me know and I''ll provide instructions.

OK


按如下方式设置字段的默认值：


= IIf（增值税=是，[价格] +（（[价格] * 17）/ 100），[价格]）


因为我不喜欢17％不知道你的增值税是多少。

OK

Make the default value of the field as follows:

=IIf(vat="Yes",[price]+(([price]*17)/100), [price])

I used 17% as I don''t know what your vat rate is.

这篇关于以另一个为条件制作场地的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！