Need formula to sum values before and after unchecked checkbox.

[bonkers]

I'm looking for help with an expression/formula. Situation: Text23 is the
subtotal///Checkbox29 is the check box that would be checked if customer is
required to pay sales tax///and Text32 to the tax amount. I am having
problems with the formula, I keep getting #Name? in text32. This is the
formula that I have started with in Text32 =if(check29="Y",(text26*.08)).

Thank you in advance to whomever can help me.

 

[Gina Whipp]

Bonkers,

Try: =IIf([check29]=-1,([text26]*.08))

Checkboxes do not store Y/N, their values are -1 or 0 or Null

 

[Gina Whipp]

You're welcome

--
Gina Whipp

THANK YOU, THANK YOU, THANK YOU!!!!!!! I had been working days trying to
make the expression work. I learned something new today.
Again, Thanks,

Bonkers,

Try: =IIf([check29]=-1,([text26]*.08))

Checkboxes do not store Y/N, their values are -1 or 0 or Null

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" -
Tremors
II

I'm looking for help with an expression/formula. Situation: Text23 is
the
subtotal///Checkbox29 is the check box that would be checked if
customer
is
required to pay sales tax///and Text32 to the tax amount. I am having
problems with the formula, I keep getting #Name? in text32. This is
the
formula that I have started with in Text32
=if(check29="Y",(text26*.08)).

Thank you in advance to whomever can help me.

 

[bonkers]

THANK YOU for responding back with the information, I was unaware what -1 and
0 represented. Again thanks for helping.

It isn't clear if this regards a form or report. Do yourself a favor and
rename your controls so they make sense. You might not have issues
with"Checkbox29" vs "check29" and "text23" vs "text26".
A check box value might be either True/-1 or False/0. Also, the function is
IIf(). Try:
=IIf([check29]=True,([text26]*.08))


--
Duane Hookom
Microsoft Access MVP

I'm looking for help with an expression/formula. Situation: Text23 is the
subtotal///Checkbox29 is the check box that would be checked if customer is
required to pay sales tax///and Text32 to the tax amount. I am having
problems with the formula, I keep getting #Name? in text32. This is the
formula that I have started with in Text32 =if(check29="Y",(text26*.08)).

Thank you in advance to whomever can help me.