验证帮助 [英] Validation Help
问题描述
我有一个计算税收的数据库。我有两类住宅和商业物业。这是信息
访问:
2003
字段:
PCC (文字)
ORG-BLDG-VAL-C(货币)
ORG-BLDG-VAL-R(货币)
我想做的是。
如果输入的密码为100到199,它们必须填写org-bldg-val-r字段。
如果输入的密码为300到599,它们就是必须填写org-bldg-val-c字段。
如果输入的pcc代码为0 ??到099,它们必须填写两个字段字段。
Pcc代码100-299是住宅物业,300-599是商业类物业。您不能拥有具有商业价值的住宅代码或具有住宅价值的商业代码。我们使用2种不同的税率。 (现在如果PCC代码以零(0)开头,那么将使用这两个字段。
请告知
任何有关这方面的帮助都会很棒!
您是否正在使用表单来允许用户输入数据?如果是,那么控件是什么?
或者他们是否进入直接进入表?
您是否使用表单允许用户输入数据?如果是,那么控件是什么?
或者他们是否直接进入表格?
他们将数据输入表格。至于控件,不确定你的意思?
I have a database that calculates taxes. I have two classes of properties Residential and Commercial. Here is the information
Access:
2003
Fields:
PCC (Text)
ORG-BLDG-VAL-C (Currency)
ORG-BLDG-VAL-R (Currency)
What I want to do is.
If entered a pcc code of 100 to 199, they MUST fill the org-bldg-val-r field.
If entered a pcc code of 300 to 599, they MUST fill the org-bldg-val-c field.
If entered a pcc code of 0?? to 099, they MUST fill both fields fields.
Pcc codes 100-299 are residential properties and 300-599 are commercial class properties. You can?t have a residential code with a commercial value or a commercial code with a residential value. We use 2 different tax rates. (now if the PCC codes starts with Zero (0), then both fields will be used.
Please advise
Any help with this would be great!
Are you using a form to allow the user to enter data? If so what controls?
Or are they entering directly into the table?
Are you using a form to allow the user to enter data? If so what controls?
Or are they entering directly into the table?They enter the data in to a form. As for controls, not sure what you mean?
这篇关于验证帮助的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!