SUM calculation

[Matt]

I have a report set up like this:


DETAIL

"roofDes" "Info" "labor$sqft" "Square Feet"
"=nz([labor$sqft]*[square feet])"


ROOFDES FOOTER


"=nz(Sum([Subtotal2]))"

*The name of "=nz([labor$sqft]*[square feet])" is Subtotal2. The problem is
my SUM doesnt recognize subtotal2 and im not getting my Total. Is there a way
this can be done?

 

[Lynn Trapp]

"=nz(Sum([Subtotal2]))"

Try changing the field in the footer to "=nz(Sum([labor$sqft]*[square
feet]))"

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Access Junkie List:
http://home.bendbroadband.com/conradsystems/accessjunkie.html