Sum

  • Thread starter Thread starter Ralph Tomaccio
  • Start date Start date
R

Ralph Tomaccio

I have been racking my brains out for hours trying to get
a "Sum" of one field in a report. Everything else is
formated nicely and I just can't get it to appear.

In design view I created a text box, clicked Properties,
selected Control Source and inserted the formula: =Sum
([FieldName]) and when I go to Layout or Print View, it
shows "#ERROR" in the report.

Exactly what am I doing wrong? Your help is most
appreciated.
 
Hi Ralph,

Take a look at this article:
ACC2000: Troubleshooting Tips for Error Values
http://support.microsoft.com/default.aspx?scid=kb;en-us;209132

I hope this helps! If you have additional questions on this topic, please
respond back to this posting.


Regards,

Eric Butts
Microsoft Access Support

"Microsoft Security Announcement: Have you installed the patch for
Microsoft Security Bulletin MS03-026? If not Microsoft strongly advises
you to review the information at the following link regarding Microsoft
Security Bulletin MS03-026
<http://www.microsoft.com/security/security_bulletins/ms03-026.asp> and/or
to visit Windows Update at <http://windowsupdate.microsoft.com/> to install
the patch. Running the SCAN program from the Windows Update site will help
to insure you are current with all security patches, not just MS03-026."


--------------------
| Content-Class: urn:content-classes:message
| From: "Ralph Tomaccio" <[email protected]>
| Sender: "Ralph Tomaccio" <[email protected]>
| Subject: Sum
| Date: Wed, 25 Feb 2004 14:41:18 -0800
| Lines: 11
| Message-ID: <[email protected]>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="iso-8859-1"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| X-MIMEOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
| Thread-Index: AcP78HvvXJYByDA+QCiMQ+qlYCXCsw==
| Newsgroups: microsoft.public.access.reports
| Path: cpmsftngxa06.phx.gbl
| Xref: cpmsftngxa06.phx.gbl microsoft.public.access.reports:131880
| NNTP-Posting-Host: tk2msftngxa12.phx.gbl 10.40.1.164
| X-Tomcat-NG: microsoft.public.access.reports
|
| I have been racking my brains out for hours trying to get
| a "Sum" of one field in a report. Everything else is
| formated nicely and I just can't get it to appear.
|
| In design view I created a text box, clicked Properties,
| selected Control Source and inserted the formula: =Sum
| ([FieldName]) and when I go to Layout or Print View, it
| shows "#ERROR" in the report.
|
| Exactly what am I doing wrong? Your help is most
| appreciated.
|
 
Ralph,
What section of the report is the =Sum([fieldName]) in? Try moving it to
the report footer section.

Thanks,
Thomas J. Kroljic
 
The Sum field I am trying to create is in the footer
section.

I read the article that was suggested but it didn't
really tell me anything I already didn't know. I've tried
all different combinations in the formula and nothing
seems to work.

I'm certain it's something very basic that I'm not
realizing but, with my very limited and very infrequent
use and knowledge of Access, I just can't figure out what
the problem is. I've gone through all the help info and,
because I'm unfamiliar with much of the terminology, when
I try to become familiar with a new term, it leads me to
something else I don't know.

It sure would be nice if the software had a featurte
where all that one needs to do is select the field, then
select the function desired and "BAM", the formula is
entered. I realize there are too many ways to use
functions, but it should be available for at least the
most commonly used ones - like "Sum".

Any other suggestions?
 
Thomas asked you which footer section. There are at least three different
types of footer sections. Sum() won't work in one of them. Also, tell us the
name of the control as well as the control source. It wouldn't hurt to tell
us the data type of the field.
 
Ah, yes! After reading the posts again after posting my
response, I did discover that I was trying to put the Sum
field in the Page Footer area. There was no Report Footer
area showing originally. It has been moved to the Report
Footer area and does work.

Is the Report Footer suppose to be below the Page Footer
area? It seems it should be above the Page Footer section
only because the actual field in the report is above the
Page Footer. Seems illogical based on that.

In my search for help, no where did I read a formula
would not work in a particular section, or that it had to
be in the Report Footer.
 
I just checked Help in 2002 and it mentions totals in group and report
headers and footers. It even mentions how to sum calculated expressions and
that your name should not be the same as a field. I was impressed for once.
 
I'm surprised too. I'm glad it's there. I sure couldn't
find it though. Of course, it's easy to miss things when
the frustration level is HIGH, as mine was.

Thanks for all the help.
Ralph
 
Back
Top