On Wed, 28 Oct 2009 17:24:11 -0700, dcrqueens
wrote:

I am trying to add 3 fields in a form using an unbound text box as follows:
=Nz(RES,0)+(Nz(CRE,0). The formula simply takes what is in the field and puts
them together in the unbound text box. So if there is the following RES 2,
CRE 3, I get 23 in the unbound text box. Can someone please tell me when I am
going wrong?

It's treating the values as text strings (for which + is a concatenation
operator) rather than as numbers. Try

=Val([Res]) + Val([CRE])

--

John W. Vinson [MVP]