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])
-- 
Taylor

Taylor

Where are you putting this formula?

Regards

Jeff Boyce
Microsoft Office/Access MVP

"TaylorLeigh" <TaylorLeigh@discussions.microsoft.com> wrote in message 
news:42878E09-FA72-42DF-B371-0533563347D6@microsoft.com...
>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])
> -- 
> Taylor 

Did you try putting it in the AfterUpdate event of the Customers_Taxable 
checkbox?
-- 
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

"TaylorLeigh" <TaylorLeigh@discussions.microsoft.com> wrote in message 
news:42878E09-FA72-42DF-B371-0533563347D6@microsoft.com...
>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])
> -- 
> 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


"TaylorLeigh" wrote:

> 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])
> -- 
> Taylor

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


"KARL DEWEY" wrote:

> 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
> 
> 
> "TaylorLeigh" wrote:
> 
> > 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])
> > -- 
> > Taylor

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


"TaylorLeigh" wrote:

> 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
> 
> 
> "KARL DEWEY" wrote:
> 
> > 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
> > 
> > 
> > "TaylorLeigh" wrote:
> > 
> > > 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])
> > > -- 
> > > Taylor

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

"KARL DEWEY" <KARLDEWEY@discussions.microsoft.com> wrote in message 
news:A09CCAB7-94FA-4303-AB04-73AA062B66FE@microsoft.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
>
>
> "TaylorLeigh" wrote:
>
>> 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
>>
>>
>> "KARL DEWEY" wrote:
>>
>> > 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
>> >
>> >
>> > "TaylorLeigh" wrote:
>> >
>> > > 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])
>> > > -- 
>> > > Taylor