 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Reports / Printing / March 2005Calculation on a Report
I'm trying to create a formula in the report footer that will calculate values greater than 12. For example, if a value is 12 or less I don't want to calculate it, if the value is greater than 12 I want to multiply the amount greater than 12 by 5.5 (if 16 then 5.5 X 4). Your help is appreciated. >I'm trying to create a formula in the report footer that will calculate >values greater than 12. For example, if a value is 12 or less I don't want to >calculate it, if the value is greater than 12 I want to multiply the amount >greater than 12 by 5.5 (if 16 then 5.5 X 4). Your help is appreciated. Try an expression like: =IIf(thevalue > 12, 5.5 * (thevalue - 12), thevalue)  SignatureMarsh MVP [MS Access] Marshall, I tried that formula. I have one record with a value of 16. I should get 22 as the sum (16-12=4*5.5). With the IIF statement Im getting 12? > >I'm trying to create a formula in the report footer that will calculate > >values greater than 12. For example, if a value is 12 or less I don't want to [quoted text clipped - 4 lines] > > =IIf(thevalue > 12, 5.5 * (thevalue - 12), thevalue) I don't see how that's possible using the expression I posted. Could you Copy/Paste the text box's ControlSource property into a reply so I can see **exactly** what you have. SignatureMarsh MVP [MS Access] >I tried that formula. I have one record with a value of 16. I should get 22 >as the sum (16-12=4*5.5). With the IIF statement Im getting 12? [quoted text clipped - 7 lines] >> >> =IIf(thevalue > 12, 5.5 * (thevalue - 12), thevalue) Marshall, I ended up changing the sql statement on the report and summed the text box. Thanks for your help. > I don't see how that's possible using the expression I > posted. Could you Copy/Paste the text box's ControlSource [quoted text clipped - 11 lines] > >> > >> =IIf(thevalue > 12, 5.5 * (thevalue - 12), thevalue) Sum?? Where did a Sum come into the question? If that's was what you were tring to do all along, you should have said so. Maybe the latest issue is that you were trying to Sum a text box. This will never work because the aggregate functions only know how to operate on fields in the RecordSource table/query. Moving the expression to the query is a godd way to resolve the issue. The other is to use a text box that Sums the expression, not a text box with the expression. SignatureMarsh MVP [MS Access] >I ended up changing the sql statement on the report and summed the text box. >Thanks for your help. [quoted text clipped - 15 lines] >> >> >> >> =IIf(thevalue > 12, 5.5 * (thevalue - 12), thevalue) |
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.