What does all that mean? Is if represensented by a symbol.
Iif() - Immediate If - is the name of a builtin Access function. To
break this down into logical bits:
=[Price] * (1 + IIf([Taxable], [TaxRate], 0))
= means "An expression follows, set this textbox to display the result
of the expression"
[Price] should be replaced by the name of the field in your table
which contains the price
That price will by multiplied (* is the multiplication operator) by
the expression in parentheses
If the item is not taxable, you want to multiply by 1 (that is, just
have the expression return the untaxed price); if it is taxable, you
want to multiply by 1.065 if the tax rate is 6.5%, or 1 plus whatever
the taxrate is. I assumed that you have a yes/no field named [Taxable]
which is TRUE if the item is taxable, and another field [TaxRate]
containing the percentage tax rate.
The IIF function takes three arguments: it evaluates the first one as
being either TRUE or FALSE. If it is TRUE, it returns the second
argument; if FALSE, it returns the third. So the IIF function will
return 0.065 if [Taxable] is True and [TaxRate] is 0.065 (=6.5%); if
[Taxable] is False, then it doesn't matter what the taxrate is, the
IIF function will return 0, the third argument.
You would change the fieldnames to match those in your table (which of
course I cannot see) and put the entire expression into the Control
Source property of a textbox on the form to calculate and display the
price including the sales tax. Rounding to even cents is probably a
good idea too: so you would use instead
=Round([Price] * (1 + IIf([Taxable], [TaxRate], 0)), 2)
John W. Vinson[MVP]
