Simple Calculation

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to add 3 fields and put the result in a 4th. In the Control
Source of the Form Design view, I type =[Amount1]+[Amount2]+[Amount3}, just
like I did on another form, but it does nothing. No error messages...just
nothing. can anybody help?
 
Dear Wayne,

This is in reply of your answer - I would like to know , how can I learn
where to put the open brackets and closed brackets and also the following
{ } [ ] ( )
- how to understand the importance of the above characters - please I am
just learning

Rgds
Anver

Wayne-I-M said:
Hi

Use this

=Nz([Amount1])+Nz([Amount2])+Nz([Amount3])


--
Wayne
Manchester, England.
Not an expert.
Enjoy whatever it is you do.



Rich D said:
I am trying to add 3 fields and put the result in a 4th. In the Control
Source of the Form Design view, I type =[Amount1]+[Amount2]+[Amount3}, just
like I did on another form, but it does nothing. No error messages...just
nothing. can anybody help?
Click to expand...
Click to expand...
 
Back
Top