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

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

Post by ryan.fitzp » Fri, 11 Apr 2008 03:09:54


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
 
 
 

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

Post by Marshall B » Fri, 11 Apr 2008 04:43:41


=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.

--
Marsh
MVP [MS Access]

 
 
 

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

Post by ryan.fitzp » Fri, 11 Apr 2008 04:55:53

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

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

Post by Marshall B » Fri, 11 Apr 2008 07:30:44

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.
--
Marsh
MVP [MS Access]