Sub form totaling help?

[Xenos132]

I have a sub form based on my parts table. The form is a Continuous Form. On this form I have a unbound (Total) text box where I run the calculation =[List Price]*[Quanity]*(1-[Discount])*(1+[PST])*(1+[Markup]). This part works well.

In the footer I also have an unbound text box where I am trying to total the Total field however I just can’t get to it total. I though it would as simple as =Sum([Total]) however it doesn’t work.

Tip anyone???

 

[Pampers]

Is the name-propery of the Total-field in the subform also called Total

Pampers
Just became father!

 

[PHV]

You may try this:
=Sum([List Price]*[Quanity]*(1-[Discount])*(1+[PST])*(1+[Markup]))

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[Xenos132]

I guess I shouldn’t have used the term Subform, right now it’s just a form that will become my parts subform on my orders form. It doesn’t appear to be a name problem Could it be a null value Problem? I know some of the totals are blank.

 

[PHV]

Have a look at the Nz function.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[Xenos132]

PHV
I tired it… =Nz([List Price]*[Quanity]*(1-[Discount])*(1+[PST])*(1+[Markup]),0)

This may help, if I just use =([Total]) It will give me the value on the cell I click on. But as soon as I put =Sum([Total]) I get #Error

 

[PHV]

And this ?
=Sum(Nz([List Price]*[Quanity]*(1-[Discount])*(1+[PST])*(1+[Markup]),0))

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[Xenos132]

OK why didn't I think of that... LAZY...

thanks.. Strange that Summing the field didn;t work. OH well that did.