 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Forms / March 2007Sum not working
I have a subform and at the botom of the form I have a field called subtotal which is the sum of the extprice. I have just installed the database on a system with Vista and Access 2007 on it and for some unknown reason the field will not sum up the values in extprice the control source is =sum(extprice) I have installed the same database (in access 2000, Xp and 2003) onto the new computer and the problem is the same, yet when I look at it on my computer in Access 2007 everything appears fine, anyone got any ideas Thanks Hi Nigel, is ExtPrice a calculated field? If so, try something like this: ControlSource --> =Sum([Qty_control] * [price_control]) in other words, use the same equation in the Sum as you do in the extended price :) Warm Regards, Crystal * (: have an awesome day :) * MVP Access Remote Programming and Training strive4peace2006 at yahoo.com * > I have a subform and at the botom of the form I have a field called subtotal > which is the sum of the extprice. I have just installed the database on a [quoted text clipped - 10 lines] > > Thanks extprice works fine, its the sum(extprice) in the form footer that is not working > Hi Nigel, > [quoted text clipped - 31 lines] > > > > Thanks Hi Nigel, yes, I realize that ... but is extprice a calculated field? If so, you need to use the equation in the Sum, not the control reference to extprice Warm Regards, Crystal * (: have an awesome day :) * MVP Access Remote Programming and Training strive4peace2006 at yahoo.com * > extprice works fine, its the sum(extprice) in the form footer that is not > working [quoted text clipped - 34 lines] >>> >>> Thanks Ext price is calculated using code, the strange thing is that it works on my computer which has access 2007 but not on the other computer which also has Access 2007. > Hi Nigel, > [quoted text clipped - 49 lines] > >>> > >>> Thanks Hi Nigel, why are you calculating it with code instead of an equation in the ControlSource? don't know what to say on it working on one machine and not the other except to ask if you have all the updates... Warm Regards, Crystal * (: have an awesome day :) * MVP Access Remote Programming and Training strive4peace2006 at yahoo.com * > Ext price is calculated using code, the strange thing is that it works on my > computer which has access 2007 but not on the other computer which also has [quoted text clipped - 53 lines] >>>>> >>>>> Thanks |
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.