If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Sum() function in report returns #Error in Access 2000
I am trying to create a report to generate an invoice, and I need it to total
my fees in a reasonable manner. In the detail section of my report I have a control that is bound to the source [Fee] from my query, which lists my fee for each date of services provided. (The name of this control in the report is [Text25]). I would like, following the list of amounts, to list a total sum for the invoice. I tried placing a control in the page footer with the expression =Sum([Fee]), but that returned a value of #Error. I tried =Sum([Text25]), but got the same results. I tried placing =Sum([Fee]) in the detail section and I got an accurate total, but it listed the total after each line entry of DATE-HOURS-FEE which isn't especially useful to me. What is the underlying problem, and what is the best way to fix it, please? |
#2
|
|||
|
|||
Sum() function in report returns #Error in Access 2000
On Fri, 17 Aug 2007 08:42:41 -0700, KT Huggs wrote:
I am trying to create a report to generate an invoice, and I need it to total my fees in a reasonable manner. In the detail section of my report I have a control that is bound to the source [Fee] from my query, which lists my fee for each date of services provided. (The name of this control in the report is [Text25]). I would like, following the list of amounts, to list a total sum for the invoice. I tried placing a control in the page footer with the expression =Sum([Fee]), but that returned a value of #Error. I tried =Sum([Text25]), but got the same results. I tried placing =Sum([Fee]) in the detail section and I got an accurate total, but it listed the total after each line entry of DATE-HOURS-FEE which isn't especially useful to me. What is the underlying problem, and what is the best way to fix it, please? See Microsoft KnowledgeBase article: 132017 "How to sum a column of numbers in a report by page" -- Fred Please respond only to this newsgroup. I do not reply to personal e-mail |
#3
|
|||
|
|||
Sum() function in report returns #Error in Access 2000
I looked at article 132017 before I posted. I couldn't understand it because
I do not know VBA. Plus, the summary states: "SUMMARY In a Microsoft Access report, you can sum a column of numbers by group or over the entire report, but there is no built-in way to print the sum of a column on each page of a report. This article shows you how you can use code to print the sum of a column of numbers on each page of a report. " I do not want to print the sum on each page of the report. I only want one total printed at the bottom of the report. (I'm afraid I will need an answer explained simply. I took a free crash course in Access basics once and used that to patch up an existing badly created database, but this is the first DB I have ever made from scrach.) "fredg" wrote: On Fri, 17 Aug 2007 08:42:41 -0700, KT Huggs wrote: I am trying to create a report to generate an invoice, and I need it to total my fees in a reasonable manner. In the detail section of my report I have a control that is bound to the source [Fee] from my query, which lists my fee for each date of services provided. (The name of this control in the report is [Text25]). I would like, following the list of amounts, to list a total sum for the invoice. I tried placing a control in the page footer with the expression =Sum([Fee]), but that returned a value of #Error. I tried =Sum([Text25]), but got the same results. I tried placing =Sum([Fee]) in the detail section and I got an accurate total, but it listed the total after each line entry of DATE-HOURS-FEE which isn't especially useful to me. What is the underlying problem, and what is the best way to fix it, please? See Microsoft KnowledgeBase article: 132017 "How to sum a column of numbers in a report by page" -- Fred Please respond only to this newsgroup. I do not reply to personal e-mail |
#4
|
|||
|
|||
Sum() function in report returns #Error in Access 2000
Add a report footer and add a control to the report footer with a source of
=Sum(Fee) You can't put that in the page footer, it will not work. -- John Spencer Access MVP 2002-2005, 2007 Center for Health Program Development and Management University of Maryland Baltimore County .. "KT Huggs" wrote in message ... I looked at article 132017 before I posted. I couldn't understand it because I do not know VBA. Plus, the summary states: "SUMMARY In a Microsoft Access report, you can sum a column of numbers by group or over the entire report, but there is no built-in way to print the sum of a column on each page of a report. This article shows you how you can use code to print the sum of a column of numbers on each page of a report. " I do not want to print the sum on each page of the report. I only want one total printed at the bottom of the report. (I'm afraid I will need an answer explained simply. I took a free crash course in Access basics once and used that to patch up an existing badly created database, but this is the first DB I have ever made from scrach.) "fredg" wrote: On Fri, 17 Aug 2007 08:42:41 -0700, KT Huggs wrote: I am trying to create a report to generate an invoice, and I need it to total my fees in a reasonable manner. In the detail section of my report I have a control that is bound to the source [Fee] from my query, which lists my fee for each date of services provided. (The name of this control in the report is [Text25]). I would like, following the list of amounts, to list a total sum for the invoice. I tried placing a control in the page footer with the expression =Sum([Fee]), but that returned a value of #Error. I tried =Sum([Text25]), but got the same results. I tried placing =Sum([Fee]) in the detail section and I got an accurate total, but it listed the total after each line entry of DATE-HOURS-FEE which isn't especially useful to me. What is the underlying problem, and what is the best way to fix it, please? See Microsoft KnowledgeBase article: 132017 "How to sum a column of numbers in a report by page" -- Fred Please respond only to this newsgroup. I do not reply to personal e-mail |
#5
|
|||
|
|||
Sum() function in report returns #Error in Access 2000
Use the Report Footer, rather than the page footer, to place your sum text
box. Also, be sure that there is no circular reference. Text box fee and sum of fee need to have different names. "KT Huggs" wrote: I am trying to create a report to generate an invoice, and I need it to total my fees in a reasonable manner. In the detail section of my report I have a control that is bound to the source [Fee] from my query, which lists my fee for each date of services provided. (The name of this control in the report is [Text25]). I would like, following the list of amounts, to list a total sum for the invoice. I tried placing a control in the page footer with the expression =Sum([Fee]), but that returned a value of #Error. I tried =Sum([Text25]), but got the same results. I tried placing =Sum([Fee]) in the detail section and I got an accurate total, but it listed the total after each line entry of DATE-HOURS-FEE which isn't especially useful to me. What is the underlying problem, and what is the best way to fix it, please? |
Thread Tools | |
Display Modes | |
|
|