sum([Field])

[Felix]

i have a txtBox its control source is sum([FieldName]) in
a subForm, it works fine with first few records (less than
10) after that the #Name? display! can't figure out please
help

 

[Rolls]

Make it =([sum])

 

[Rolls]

=sum([FieldName])

Should begin the expression with equal sign.

 

[Felix]

Sorry the completed syntax is =sum(FieldName) and it doesn't work
Seek for help....

 

[Guest]

The text box name shouldn't be the same with the Field
Name. For example, if you have a text box called Quantity
and the value is =sum(Quantity), you'll get that error.

Elda