 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / New Users / September 2004Problem with calculated field
I am setting up an Invoice report using a query. The query has a calculated field, "Extended price" (UnitPrice*Quantity). So far so good, I can display all of this in the detail of the report. I want to put the sum of all the extended prices in the footer as "Subtotal". The Orders Subform in Northwind does this simply with =Sum([ExtendedPrice]) but I get #Error if I try this. How can I achieve this. Any help appreciated. Thanks John >I am setting up an Invoice report using a query. The query has a calculated > field, "Extended price" (UnitPrice*Quantity). So far so good, I can display > all of this in the detail of the report. I want to put the sum of all the > extended prices in the footer as "Subtotal". The Orders Subform in Northwind > does this simply with =Sum([ExtendedPrice]) but I get #Error if I try this. > How can I achieve this. Any help appreciated. Which footer? Page Header/Footers do not support aggregate functions. Group or Report Header/Footers should work though.  SignatureI don't check the Email account attached to this message. Send instead to... RBrandt at Hunter dot com It works ok in the group footer, but that's no good to me. That will give a subtotal for each group of data on the report, but what I need is a subtotal of all the exteded prices in the report. John > >I am setting up an Invoice report using a query. The query has a calculated > > field, "Extended price" (UnitPrice*Quantity). So far so good, I can display [quoted text clipped - 10 lines] > to this message. Send instead to... > RBrandt at Hunter dot com John, Sum doesn't work with a named calculated field such as Sum([ExtendedPrice]). Rather you need to put the calculateion inside the function as Sum([UnitPrice]*[Quantity]). -- PC Datasheet Your Resource For Help With Access, Excel And Word Applications resource@pcdatasheet.com www.pcdatasheet.com > I am setting up an Invoice report using a query. The query has a calculated > field, "Extended price" (UnitPrice*Quantity). So far so good, I can display [quoted text clipped - 6 lines] > > John Tried this and it works in the group footer but not in page footer John > John, > [quoted text clipped - 22 lines] > > > > John > Tried this and it works in the group footer but not in page footer Report Footer will work SignatureI don't check the Email account attached to this message. Send instead to... RBrandt at Hunter dot com > Tried this and it works in the group footer but not in page footer > [quoted text clipped - 28 lines] >>> >>> John John, In his first reply to your original post Rich Brandt told you you cannot use this expression in a Page Footer!! From his reply: Which footer? Page Header/Footers do not support aggregate functions. Group or Report Header/Footers should work though. If you wish to show sums (even Sums of Sums) in the Page Footer, read Microsoft KnowledgeBase article: 132017 'How to sum a column of numbers in a report by page.' SignatureFred Please only reply to this newsgroup. I do not reply to personal email. |
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.