#error when trying to sum a total

T

tinyevil777

Registered User.
Local time
Today, 00:21
Joined
Dec 10, 2010
Messages
137
Hey there,

There are ALOT of threads on this topic, and i've spent the last hour reading them and trying out different things, however i'm STILL stuck.

In a nutshell... I have a table consisting of 4 records, each record having a £ value. When i run the report, in the footer, i want each record's value to be added up, thus giving me a total.

The value field is called "Value".

I have tried using:

=Sum([Value])

and

=Sum(Nz([Value]))

in an unbound textbox in the footer, however i recieve an "#error" everytime i run the report.


i have NO idea why this isn't working, and wondered if one of you kind people could shed light on it for me?


Have attached the db for your persual :)


Thanks in advance!

Tom
 

Attachments

You don't put totals on the page footer, you need to either create group footers or put it on the report footer. Also do not use words suh as Value as this is an Access reserved word.
 
Take a look again you have it on the page footer
 
I'm confused.. You said i should have it on the page footer, and i do have it on the page footer?

What have i done wrong? Where should this formula be?
 
You don't put totals on the page footer, you need to either create group footers or put it on the report footer.
Click to expand...

Please read the above carefully
 
.... my bad!

Really sorry about that, thanks for your help David! You must get sick of people like me.
 
Yea, I got tired of having to type it all out when asked so I performed a search on the net and found it. They should find it easy to follow (I hope).

I thought you have this on your site already?
 
vbaInet said:
Yea, I got tired of having to type it all out when asked so I performed a search on the net and found it. They should find it easy to follow (I hope).

I thought you have this on your site already?
Click to expand...

I have a sample of how to put a sum in the main form from a subform but not the rest. And that article you posted was the first time I actually saw how to post a page total instead of group or report total. So, see - there's just so much to learn in Access, I keep learning something new very frequently. Now remembering it all is a totally different matter. :D
 
Oh, I thought you knew how to do that. We sure learn everyday.

I'm sure you put all your devices to good use to aide you in remembering things :D
 
You must log in or register to reply here.

Similar threads

D
Solved Summing in reports
Replies
9
Views
210
donkey9972
D
M
Calculating Two Query Sums even if No data present
Replies
15
Views
218
Mark_
M
T
Cannot Sum a Calculated Control in the Report Footer
Replies
11
Views
853
The_Doc_Man
The_Doc_Man
oxicottin
Solved Running sum based off another text box value
Replies
11
Views
322
Pat Hartman
P
6
Solved Round( ) not correct
Replies
12
Views
501
67philb
6

Users who are viewing this thread

Total: 1 (members: 0, guests: 1)
Back
Top Bottom