need help on a yes and no exjpression

  • Thread starter Thread starter Nokia
  • Start date Start date
N

Nokia

I have a form that uses tax rate information. I am trying
to set a tax rate depending on a yes/no Option group
option group = Tax Status
Taxable = yes
Non-Taxable = no
and looking up tax info from Form.Company Information.
[Tax Rate]

and I am trying to show the tax rate or no tax as 0.00%
out put to a field called [Tax Rate]

Any Ideas on how to do that.
 
Nokia said:
I have a form that uses tax rate information. I am trying
to set a tax rate depending on a yes/no Option group
option group = Tax Status
Taxable = yes
Non-Taxable = no
and looking up tax info from Form.Company Information.
[Tax Rate]

and I am trying to show the tax rate or no tax as 0.00%
out put to a field called [Tax Rate]

Any Ideas on how to do that.
Click to expand...
You look up information from tables, not forms.

There is no need to put it in a table and lots of reasons not to. (If you
know why you should not do it, then feel free to do it.)
I would put an expression in a query and use it in forms and reports. There
should be a relationship between the tax table and the table you want the
data in so:

Tax:iif([tax status] = "yes", [TaxRate from related table], "0.00%")
 
Back
Top