Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Trying to put a calculated field on a form

Status
Not open for further replies.
Jul 27, 2004
52
0
0
US
I have a master form that has totals by month for various things. I want to create an unbound field on this form which will total some of the fields. Please help.
Also, I just realized that my fields are text. Should I change them to number fields?
 
=Sum(Val(FieldName)) or =Val(Field1) + Val(Field2) + Val(Field3)...etc

Usually it's a good idea to use number fields when it's a number, but if you need it as text for one reason or another, leave it and use Val() to convert it to number.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top