 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Forms / May 2008Total of calculated field in a form
How can I get the total of a calculated field in a form I have tried putting the textbox in the form footer but to no avail Is there a function I could use to calculate this form total. The problem seems to be because I am using a percentage in the calculation Thanks A How are you performing the calculation? What is the calculation? If you are trying to find the sum of a calculated control you need to repeat the calculation in the text box in the form footer. You cannot simply reference the text box. If the calculation in the text box in the main part of the form is Text1 * Text2, the text box in the footer needs to be something like: Sum(Text1 * Text2) Percentage is a format, and should not affect what you are trying to do. > How can I get the total of a calculated field in a form > I have tried putting the textbox in the form footer but to no avail [quoted text clipped - 5 lines] > Thanks > A No matter what I put in the form footer it didn't give me the correct answer The formula was: (Qty * Cost * markup%) + Qty * Cost I have now used a recordset clone that appears to work fine. > How are you performing the calculation? What is the calculation? > If you are trying to find the sum of a calculated control you need to [quoted text clipped - 15 lines] >> Thanks >> A Sum([Qty] * [Cost] * (1 +[markup%]), which is a simplified version of your expression, should have worked. You should not use non-alphanumeric characters such as a percent sign in a name, but if you use such characters the name needs to be in brackets. Another option would have been to use the expression as a calculated query field, which you could have summed in the footer. You never mentioned what mathematical operation you are trying to perform in the footer (sum, average, or whatever), but as long as it is a function available to Access it should work. You could also sum the numbers within a query. I can't see how a recordsetclone will help, but if you got it working then good luck on the rest of the project. > No matter what I put in the form footer it didn't give me the correct > answer [quoted text clipped - 23 lines] >>> Thanks >>> A |
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.