Hello,
I'm new to this forum and pretty new to accces. I have taken some classes but still a greenhorn.
I have ran into a problem. On a form I have a control that calculates the amount of a line item =([Length])*([width])*[sqftPrice]. works fine. Then what I need is the Sum of those Calculated amounts. I get a #Name? when i do a =sum([calculatedfield])
Any help is appreciated. I have to use access 97 for legacy purposed.