 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Forms Programming / July 2005Math Not Working
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) --------------------------- > The second line of this code isn't working... > I need Text136 and Text140 to add and then multiply by STax... [quoted text clipped - 7 lines] > 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 [quoted text clipped - 27 lines] >>Thanks >>DS Thanks Graham... STax is actually Sales Tax! All is well now! Once again Thank You! DS |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.