Calculation Sales tax

[Guest]

I want the sales tax to calculate and show on my form. This is my formula,
but nothing appears on the form, not even an error message.

Any help would be appreciated.

Thanks,

=IIf([Customers_Taxable]=True,[Subtotal]*[Sales Tax Rate])

 

[Jeff Boyce]

Taylor

Where are you putting this formula?

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Arvin Meyer [MVP]]

Did you try putting it in the AfterUpdate event of the Customers_Taxable
checkbox?

 

[Guest]

Try this ---
=IIf([Customers_Taxable]=True,([Subtotal]*[Sales Tax
Rate])+[Subtotal],[Subtotal])

This is assuming that [Customers_Taxable] field is a boolean (Yes/No) field
and not a text field. If it is a text field that enclose True in quotes or
what ever is stored in the field to signify that it is taxable.

 

[Guest]

I tried this formula and it returned the subtotal value only, even though I
have the customer taxable as yes. On the form the tax rate is showing as
7.5%. Do I have something wrong on the sales tax rate?

Thanks,
--
Taylor

Try this ---
=IIf([Customers_Taxable]=True,([Subtotal]*[Sales Tax
Rate])+[Subtotal],[Subtotal])

This is assuming that [Customers_Taxable] field is a boolean (Yes/No) field
and not a text field. If it is a text field that enclose True in quotes or
what ever is stored in the field to signify that it is taxable.
--
KARL DEWEY
Build a little - Test a little

I want the sales tax to calculate and show on my form. This is my formula,
but nothing appears on the form, not even an error message.

Any help would be appreciated.

Thanks,

=IIf([Customers_Taxable]=True,[Subtotal]*[Sales Tax Rate])

 

[Guest]

Is your [sales tax rate] text or number. If it contains "7.5%" it is text.
It would need to be .075 to be 7.5%.

You know you can not multiply text times a number.
--
KARL DEWEY
Build a little - Test a little

I tried this formula and it returned the subtotal value only, even though I
have the customer taxable as yes. On the form the tax rate is showing as
7.5%. Do I have something wrong on the sales tax rate?

Thanks,
--
Taylor

Try this ---
=IIf([Customers_Taxable]=True,([Subtotal]*[Sales Tax
Rate])+[Subtotal],[Subtotal])

This is assuming that [Customers_Taxable] field is a boolean (Yes/No) field
and not a text field. If it is a text field that enclose True in quotes or
what ever is stored in the field to signify that it is taxable.
--
KARL DEWEY
Build a little - Test a little

I want the sales tax to calculate and show on my form. This is my formula,
but nothing appears on the form, not even an error message.

Any help would be appreciated.

Thanks,

=IIf([Customers_Taxable]=True,[Subtotal]*[Sales Tax Rate])

 

[Arvin Meyer [MVP]]

Percent is a format which can be applied to any numeric datatype (even an
autonumber)
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

Is your [sales tax rate] text or number. If it contains "7.5%" it is
text.
It would need to be .075 to be 7.5%.

You know you can not multiply text times a number.
--
KARL DEWEY
Build a little - Test a little

I tried this formula and it returned the subtotal value only, even though
I
have the customer taxable as yes. On the form the tax rate is showing as
7.5%. Do I have something wrong on the sales tax rate?

Thanks,
--
Taylor

Try this ---
=IIf([Customers_Taxable]=True,([Subtotal]*[Sales Tax
Rate])+[Subtotal],[Subtotal])

This is assuming that [Customers_Taxable] field is a boolean (Yes/No)
field
and not a text field. If it is a text field that enclose True in
quotes or
what ever is stored in the field to signify that it is taxable.
--
KARL DEWEY
Build a little - Test a little


:

I want the sales tax to calculate and show on my form. This is my
formula,
but nothing appears on the form, not even an error message.

Any help would be appreciated.

Thanks,

=IIf([Customers_Taxable]=True,[Subtotal]*[Sales Tax Rate])