Math Not Working

  • Thread starter Thread starter DS
  • Start date Start date
D

DS

The second line of this code isn't working...
I need Text136 and Text140 to add and then multiply by STax...
I'm only getting Text136*Stax
Any help appreciated.


=Dollars(IIf(Forms!Sales.SalesDetails.Form!Text136>0,
(Forms!Sales.SalesDetails.Form!Text136+Forms!Sales.SalesDetails.Form!Text140)*[STax],
Forms!Sales.SalesDetails.Form!Text136*[STax]))

Thanks
DS
 
That's what you've told it to do. If you want to multiply the sum of Text136
and Text140, then use the following code. If either Text136 OR Text140 is
greater than zero, then it adds Text136 to Text140, then multiplies the
result by STax.

=IIf(Forms!Sales.SalesDetails.Form!Text136>0 or
Forms!Sales.SalesDetails.Form!Text140>0,
(Forms!Sales.SalesDetails.Form!Text136+Forms!Sales.SalesDetails.Form!Text140)*[STax],
0)

But I have to ask, what is STax? Is it the name of a form control, or the
name of a table/query field?

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia
(Currently in Japan)
 
Graham said:
That's what you've told it to do. If you want to multiply the sum of Text136
and Text140, then use the following code. If either Text136 OR Text140 is
greater than zero, then it adds Text136 to Text140, then multiplies the
result by STax.

=IIf(Forms!Sales.SalesDetails.Form!Text136>0 or
Forms!Sales.SalesDetails.Form!Text140>0,
(Forms!Sales.SalesDetails.Form!Text136+Forms!Sales.SalesDetails.Form!Text140)*[STax],
0)

But I have to ask, what is STax? Is it the name of a form control, or the
name of a table/query field?

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia
(Currently in Japan)
---------------------------

The second line of this code isn't working...
I need Text136 and Text140 to add and then multiply by STax...
I'm only getting Text136*Stax
Any help appreciated.


=Dollars(IIf(Forms!Sales.SalesDetails.Form!Text136>0,
(Forms!Sales.SalesDetails.Form!Text136+Forms!Sales.SalesDetails.Form!Text140)*[STax],
Forms!Sales.SalesDetails.Form!Text136*[STax]))

Thanks
DS
Click to expand...
Click to expand...
Thanks Graham... STax is actually Sales Tax!
All is well now!
Once again Thank You!
DS
 

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

Nested IF 7
Set focus on a different Form 1
IF Statement Not Working 9
Combo/List Box Coding 1
expression not working??? 6
Flickering Fields 1
Code is not working....please take a look!!! 5
It Says NO CURRENT RECORD 2

Back
Top