Summing Totals

ph00086

Registered User.
Local time
Today, 09:38
Joined
Aug 22, 2012
Messages
16
Hi,

My report shows me 4 things in a table layout, Part Number, Amount Produced thats acceptable, Scrap, Rework. I have totals at the bottom of these columns for the last three things.

I need a total of the last three things together so i can get a total made, how would i go about doin this?

Thanks
 
You said you have a total of the last three things already so what do you mean by you need a total of the last three things together?
 
sorry about that,

basically three coloums with totals for each in the footer, i want a total of these totals. (as shown in the pic)

Thanks
 

Attachments

  • Access Issue.png
    Access Issue.png
    16.1 KB · Views: 90
Alright, that was what I thought you wanted but it needed clarity.

All you do is add up those three textboxes together:

=textbox1 + textbox2 + textbox3
 
thanks that makes sense,

stupid question, but that does that go in a txt box and how do i get a new txt box on 2010 as i cant find one. When i copy one i've already got and put that in nothing happens on the report.
 
Yes in the Control Source of a textbox. I don't understand your second question.
 
sorry was me being stupid, couldnt find where you got a New txt box from.

I worked it out, doesnt work if there is no data in any of the txtboxes.

Thanks.
 
=Nz(textbox1, 0) + Nz(textbox2, 0) + Nz(textbox3, 0)
 

Users who are viewing this thread

Back
Top Bottom