text box summing up other text box but going into table field

[ryan.fitzpatrick3]

I have a text box in a form that is linked to a table field. I want
this text box to sum up 3 other text boxes, how do I do this, will it
save that result in the table? Thanks

ryan

 

[Marshall Barton]

I have a text box in a form that is linked to a table field. I want
this text box to sum up 3 other text boxes, how do I do this, will it
save that result in the table? Thanks

=textboxa + textboxb + textbox3

And no, that will not and should not save the total to a
table. Saving a value that can be calculated from other
values in the record might be an ok thing to do in a
spreadsheet, but is serious No-No in a database.

 

[ryan.fitzpatrick3]

Thanks Marsh, so in the table just add the 3 fields together in a new
field right?

 

[Marshall Barton]

No. You can not do calculation in a table field. Even if
you could, it would be a really bad idea. Generally it is
way more efficient and undoubtedly more reliable to
recalculate than to store the result.

The "right" way is to use a query and do the calculation in
a query field OR as I suggested you do with a text box
expression.