If then Statement

G

Guest

I have a form that has a yes/no for taxable. This form also has a calculated
subtotal. I want an if taxable then subtotal * sales tax formula.

Thanks for your help
 
G

Guest

In the ControlSource of the text box write

=IIf([TaxField]=True,[subtotal] * [sales tax],[subtotal])

Make sure that the fields name are correct
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Fields with zero values 2
How to use an IF Statement in Access 1
Text Box troubles displaying text 2
Tax Invoice 1
Building a Custom Calc in Access 4
Default Value 3
Building expression problem using Access Query. 4
"What-if" formula for either a manual entry and automated entry 3

Top