Sales Tax on Form

  • Thread starter Thread starter L. Woodhouse
  • Start date Start date
L

L. Woodhouse

I want to calculate sales tax on my form. Some clients
would be exempt. On the PST box, how do I say

If PSTEXEMPT = true then PST=0.00
 
You said what the IF was, but not what the Else is, so put
in the Else where I put the ???....

=IIf([PSTEXEMPT]=True,[PST]=0,???)

--

Gary Miller
Gary Miller Computer Services
Sisters, OR
________________________
 
=IIf([PSTEXEMPT]=True,[PST]=0,[PST]=[Subtotal]*0.08)

This is what I have.
I have a checkbox called PSTEXEMPT.
Regardless of whether it is checked or not, I am getting an
error on the field.

#Error

Thanks!
 
Are you calling this from a text box named PST? If so,
change the name to something like txtPST. This is a common
error when a formula refers to a field and a control has the
same name.

--

Gary Miller
Gary Miller Computer Services
Sisters, OR
________________________
 
I renamed the data fields so that I know that they are
unique and am still getting an error.

PST Check Box is called PSTCHECK
PST Field is called PSTTL
SubtotalBox - contains subtotal from subform
GST - =[SubtotalBox]*0.07 <--working fine
PST -
=IIf([PSTCHECK]=True,[PSTTL]=0,[PSTTL]=[SubtotalBox]*0.08)

I am still getting #error
I feel like it is probably a bracket or something in the
subtotal *0.08 area but can't see it... any help appreciated!
 
What is the DataSource for the SubTotalBox? Is this a
calculated field or does this field hold a reference to a
control on the subform to get it's data? I have a feeling
that this may be where the problems is. The brackets look
fine.
--

Gary Miller
Gary Miller Computer Services
Sisters, OR
________________________
 
Not quite. What do you have in the line for the control
source on that one?

--

Gary Miller
Gary Miller Computer Services
Sisters, OR
________________________
 
Back
Top