Total text fields

[Denise]

Help! I am working on a deposit report which requires the user to input the
amount in coins (text19), the checks (text20) & the cash (text21). Is it
possible to total the users input? I have tried everything. Thanks you so
much in advance.

 

[Marshall Barton]

Help! I am working on a deposit report which requires the user to input the
amount in coins (text19), the checks (text20) & the cash (text21). Is it
possible to total the users input? I have tried everything. Thanks you so
much in advance.

A text box can display the total by using an expression
like:
=text19 + text20 + text21

Or if any of the value can be omitted:
=Nz(text19,0) + Nz(text20,0) + Nz(text21,0)

 

[Denise]

Marshall,

Thank you so much! You led me in the right direction. I had to use the
following in order to make it work.

=CCur([Text19])+CCur([Text21])+CCur([Text22])