=[QTY]*[Price Per Unit] Need Help Please just a little rusty 12/22/2008 2:31:01 PM The below formula works great but, what if I want the total from this formula to report into my table? For example: =[QTY]*[Price Per Unit] Price: 5.00 Qty: 2 Total: 10.00 The Price and Qty will report to my table but no sum. I know what is wrong I have a formula in the control field. But how do I get both the heading of the table and the formula to work in the control field at the same time? It has been a wile sence i took this in school and my mind is starting to get a little rusty. This is proby going to be a simple fix and ill feel stupid for asking when i get the answer. Thanks

Re: =[QTY]*[Price Per Unit] Need Help Please Rick Brandt <rickbrandt2[ at ]hotmail.com> 12/22/2008 2:57:01 PM On Mon, 22 Dec 2008 06:31:01 -0800, just a little rusty wrote: [Quoted Text] > The below formula works great but, what if I want the total from this > formula to report into my table? For example: > > =[QTY]*[Price Per Unit] > > Price: 5.00 > Qty: 2 > Total: 10.00 > > The Price and Qty will report to my table but no sum. I know what is > wrong I have a formula in the control field. But how do I get both the > heading of the table and the formula to work in the control field at the > same time? It has been a wile sence i took this in school and my mind > is starting to get a little rusty. This is proby going to be a simple > fix and ill feel stupid for asking when i get the answer. Thanks The correct answer is "you don't". Derived data should not be stored, but rather calculated on-the-fly as needed (just as you are in your form). If you don't want to re-write that expression over and over create a SELECT query that is basically all of the fields from your table plus an additional one with the calculation in it. Then just use that query every place you would otherwise have used the table. -- Rick Brandt, Microsoft Access MVP Email (as appropriate) to... RBrandt at Hunter dot com

Re: =[QTY]*[Price Per Unit] Need Help Please "Al Campagna" <newsgroups[ at ]comcast.net> 12/22/2008 2:57:03 PM Rusty, As a general rule, and in this instance, you would not create a field in your table to store the PriceTotal. Since you capture the Qty and the Price, you can always recalculate the PriceTotal, "on the fly", in any subsequent form, query or report. [Quoted Text] >>> I have a formula in the control field. That's the correct way to do that... with just a calculated unbound text control. -- hth Al Campagna Microsoft Access MVP http://home.comcast.net/~cccsolutions/index.html "Find a job that you love... and you'll never work a day in your life." "just a little rusty" <just a little rusty[ at ]discussions.microsoft.com> wrote in message news:C71B36E5-CAAB-462C-9D02-470E3849DE00[ at ]microsoft.com... > The below formula works great but, what if I want the total from this > formula > to report into my table? For example: > > =[QTY]*[Price Per Unit] > > Price: 5.00 > Qty: 2 > Total: 10.00 > > The Price and Qty will report to my table but no sum. I know what is > wrong > I have a formula in the control field. But how do I get both the heading > of > the table and the formula to work in the control field at the same time? > It > has been a wile sence i took this in school and my mind is starting to get > a > little rusty. This is proby going to be a simple fix and ill feel stupid > for > asking when i get the answer. Thanks >

Re: =[QTY]*[Price Per Unit] Need Help Please "Jeff Boyce" <nonsense[ at ]nonsense.com> 12/22/2008 4:57:52 PM Rick and Al have already urged you not to... Here's one of the rationales for why you don't really want to -- if you store a calculated/derived value in your table and then any change is made to any of the pieces of the calculation and/or total, the numbers are out of sync. Do you really want to create all the code you'd need to ensure that the values stay synchronized ... or just use the query Rick & Al are suggesting to re-calc the total on the fly? Good luck! Regards Jeff Boyce Microsoft Office/Access MVP "just a little rusty" <just a little rusty[ at ]discussions.microsoft.com> wrote in message news:C71B36E5-CAAB-462C-9D02-470E3849DE00[ at ]microsoft.com... [Quoted Text] > The below formula works great but, what if I want the total from this > formula > to report into my table? For example: > > =[QTY]*[Price Per Unit] > > Price: 5.00 > Qty: 2 > Total: 10.00 > > The Price and Qty will report to my table but no sum. I know what is > wrong > I have a formula in the control field. But how do I get both the heading > of > the table and the formula to work in the control field at the same time? > It > has been a wile sence i took this in school and my mind is starting to get > a > little rusty. This is proby going to be a simple fix and ill feel stupid > for > asking when i get the answer. Thanks >

RE: =[QTY]*[Price Per Unit] Need Help Please boblarson 12/23/2008 8:09:02 AM And if you are concerned about having to do this everytime you want the value (what Al, Rick and Jeff said), you can create a BASE query which is basically the table with the extra calculated field and then you can use that in all the various places you need instead of the table so then you have the calculated field when you need it. -- Bob Larson Free Tutorials and Samples at http://www.btabdevelopment.com __________________________________ "just a little rusty" wrote: [Quoted Text] > The below formula works great but, what if I want the total from this formula > to report into my table? For example: > > =[QTY]*[Price Per Unit] > > Price: 5.00 > Qty: 2 > Total: 10.00 > > The Price and Qty will report to my table but no sum. I know what is wrong > I have a formula in the control field. But how do I get both the heading of > the table and the formula to work in the control field at the same time? It > has been a wile sence i took this in school and my mind is starting to get a > little rusty. This is proby going to be a simple fix and ill feel stupid for > asking when i get the answer. Thanks >