Total text fields

  • Thread starter Thread starter Denise
  • Start date Start date
D

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.
 
Denise said:
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.
Click to expand...


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)
 
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])
 
Back
Top