Addition on forms

[dbake]

Well this should be an easy one for everyone except me. On a form i want to add multiple fields to create a total. I figured it out on tables but it seems not to work on forms:
=([total1])+([total2])
if i give both fields a value of 1 it makes 1+1=11
can anyone help please

 

[boblarson]

Your total fields are text then. Make sure that they are numeric data types or else use:

=Val([total1]+Val([total2])

 

[dbake]

thanks

that worked like a champ i appreciate all your help this works great i have been working on this for a while. i got all complicated with it and wrote it in VB but i forgot the basics. thanks again

 

[boblarson]

Glad we could help. Welcome to Access World Forums, by the way. Sorry I didn't include that in the original post.