what formula do i enter to auto sum text boxes in access?

D

Dan the Man

I am trying to take currency totals from 4 text boxes and total them in a
fifth text box. Please explain the steps excactly. Thanks, Dan the Man.
 
R

Rick B

add a new unbound control to your form or report and put something like...

=[fieldone] + [fieldtwo] + [fieldthree] + [Fieldfour]



If you are doing this in a query, add a new column to your query with
something lik...

[Total Field]: [fieldone] + [fieldtwo] + [fieldthree] + [Fieldfour]



As discussed in hundreds of posts, you DON'T do this in a table. Only in
the other objects. Saving a calculated figure in the table would be
redundant. Also, if one of the four numbers changed, then your total would
be wrong.

Hope tha thelps,

Rick B
 
Top