Calculate-Form-Error

[rosito]

I have a form based by tabl...so easy example
I have field sum1, sum2....sum30 in the tbl
Want on bottom of form show SUMALL=sum1+sum2...+sum30 (dont keep this SUMALL..just show). I think i do all right, but i see "#Name?"

 

[RuralGuy]

You do not need SUMALL. Just use =sum1+sum2...+sum30. You also have a Normalization problem.

 

[RuralGuy]

Sorry..I show my error, already (missing "=" so stupid!)... I use "SUMALL" as incorrect word ("myallsum" is right,maybe ). What is this "You also have a Normalization problem."?

Any time I see repeating field names I strongly suspect issues with normalization. You can Google for links on normalization for further details. Here's a link to get you started: http://wiki.ittoolbox.com/index.php/Normalization