By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,154 Members | 1,024 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,154 IT Pros & Developers. It's quick & easy.

Sum problem in Two Fileds

P: n/a
I have Cost Analysis form created where there are three fileds and I
want to have total of all the fileds at the end. I have created text
box which has Control Source as =[Text1]+[Text2]+[Text3]. It shows me
total of three text boxes when there are some values in all three text
boxes but if there are values in only one or two text boxes it is not
dislpaying total. Can anyone please help me to solve the problem. I am
new to access database.

Thanks,
Mukesh

Jun 26 '06 #1
Share this Question
Share on Google+
2 Replies


P: n/a
On 26 Jun 2006 06:11:05 -0700, mu************@gmail.com wrote:
I have Cost Analysis form created where there are three fileds and I
want to have total of all the fileds at the end. I have created text
box which has Control Source as =[Text1]+[Text2]+[Text3]. It shows me
total of three text boxes when there are some values in all three text
boxes but if there are values in only one or two text boxes it is not
dislpaying total. Can anyone please help me to solve the problem. I am
new to access database.

Thanks,
Mukesh


Look up the Nz function in VBA help.

=Nz([Text1]) + Nz([Text2]) + Nz([Text3])
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail
Jun 26 '06 #2

P: n/a
Thanks Fredge for your prompt response. Greatly appreicated. I will try
this function tonight and will post the answer.
Mukesh
fredg wrote:
On 26 Jun 2006 06:11:05 -0700, mu************@gmail.com wrote:
I have Cost Analysis form created where there are three fileds and I
want to have total of all the fileds at the end. I have created text
box which has Control Source as =[Text1]+[Text2]+[Text3]. It shows me
total of three text boxes when there are some values in all three text
boxes but if there are values in only one or two text boxes it is not
dislpaying total. Can anyone please help me to solve the problem. I am
new to access database.

Thanks,
Mukesh


Look up the Nz function in VBA help.

=Nz([Text1]) + Nz([Text2]) + Nz([Text3])
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail


Jun 26 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.