Hiya fredg.
Well, I tried both of your formulas, and I got the message "The Microsoft
Jet database engine could not execute the SQL statement because it contains a
field that has an invalid data type."
Now what?
Oh, yes, Proofreading Time Log is in the record source.
:
On Tue, 18 Jan 2005 13:21:04 -0800, working girl wrote:
#Name? Is the error I get when I try to total the entries.
Not all entries are complete, and if they aren't complete, they won't have
the figures coded in.
The table's function is to keep a record of the volume of work hours spent
on each given project. We calculate the total per project, enter it in the
table, and then we want Access to give us a grand total.
So, to be clear, the formula I have entered reads =SUM(Proofreading Time Log
Total) and for some reason, doesn't work.
I have always done this sort of calculations in Excel, so the way Access
uses this feature is new to me. I really appreciate the feedback.
:
On Tue, 18 Jan 2005 11:17:04 -0800, working girl wrote:
No. I have not inserted the formula in the page footer, as I do not want the
sum to appear at the bottom of the page, I want it to appear at the end of
the report.
This seems to be what most people imagine I've done incorrectly. I am
trying to find out if there is some sort of formulaic typo that I've inserted
that is impeding the calculation.
:
On Tue, 18 Jan 2005 09:25:09 -0800, working girl wrote:
I am trying to insert a formula to calculate the total of a specific kind of
entry. Each entry in the database has a numeric value and I am looking to
find the sum.
The formula I have inserted is the simple =sum(field). This is not working.
Please tell me what formula I need for simple calculation.
You are probably trying to place this sum in the report's Page Footer.
See Microsoft KnowledgeBase article:
132017 "How to sum a column of numbers in a report by page"
--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.
Then you have to be a bit more forthcoming.
'Not Working' how?
Do you get a wrong sum? an #error? no sum?
What is the EXACT control source?
What is the Name of the control? Is it the same as the name of the
Field?
Can any of the values summed be Null?
--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.
1) =SUM(Proofreading Time Log Total) wont work.
You have spaces within the field name and therefore you must surround
the field name with brackets.
=SUM([Proofreading Time Log Total])
2) Make sure the name of this control is not
"Proofreading Time Log Total"
3) Is [Proofreading Time Log Total] included in the report's record
source?
Note: If there is a chance one or more of the entries may be null, use
the Nz() function:
=SUM(Nz([Proofreading Time Log Total],0))
