View Single Post
  #1  
Old October 29th, 2009, 12:24 AM posted to microsoft.public.access.forms
dcrqueens
external usenet poster
 
Posts: 28
Default Adding Multiple Fields

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?