Adding Unbound Text Fields to Each Other

[Guest]

Hi,
I have a section on my form where users input the number of stores in each
of three areas. I want to have a TOTAL STORES item on there, but when I try
to input the formula =[numStore1]+[numStore2]+[numStore3] I get a reponse
that looks like "505050" instead of "150" which is what 50 + 50 + 50 would
be. How can I correct this?

Thanks!

 

[Douglas J. Steele]

You need to ensure that the contents gets treated as numbers.

Since the values always going to be integer values, try
=CInt([numStore1])+CInt([numStore2])+CInt([numStore3])

 

[Larry Linson]

Hi,
I have a section on my form where users input the number of stores in each
of three areas. I want to have a TOTAL STORES item on there, but when I
try
to input the formula =[numStore1]+[numStore2]+[numStore3] I get a reponse
that looks like "505050" instead of "150" which is what 50 + 50 + 50 would
be. How can I correct this?

It appears you are concatenating text instead of adding numbers. Are
[numStore1], [numStore2], and [numStore3] the names of Fields in the Form's
RecordSource, or are they the names of Controls on the Form? Are you
"inputting the formula" in the ControlSource property of "TOTAL STORES"
Control or elseswhere? Are the Fields in the Form's RecordSource that apply
to these defined as Text or Numeric?

Larry Linson
Microsoft Access MVP

 

[Guest]

Hi Larry,
The [num...] are fields on the form - not stored in a table & don't need to
be. I just need calculations to occur against these values. They are set to
numeric type and I've been inputting the values into the "Control Source"
under properties.
--
Thank you! - Jennifer

Hi,
I have a section on my form where users input the number of stores in each
of three areas. I want to have a TOTAL STORES item on there, but when I
try
to input the formula =[numStore1]+[numStore2]+[numStore3] I get a reponse
that looks like "505050" instead of "150" which is what 50 + 50 + 50 would
be. How can I correct this?

It appears you are concatenating text instead of adding numbers. Are
[numStore1], [numStore2], and [numStore3] the names of Fields in the Form's
RecordSource, or are they the names of Controls on the Form? Are you
"inputting the formula" in the ControlSource property of "TOTAL STORES"
Control or elseswhere? Are the Fields in the Form's RecordSource that apply
to these defined as Text or Numeric?

Larry Linson
Microsoft Access MVP

 

[Guest]

Thanks, that works perfect. Issue solved.
--
Thank you! - Jennifer

You need to ensure that the contents gets treated as numbers.

Since the values always going to be integer values, try
=CInt([numStore1])+CInt([numStore2])+CInt([numStore3])

--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)

Hi,
I have a section on my form where users input the number of stores in each
of three areas. I want to have a TOTAL STORES item on there, but when I
try
to input the formula =[numStore1]+[numStore2]+[numStore3] I get a reponse
that looks like "505050" instead of "150" which is what 50 + 50 + 50 would
be. How can I correct this?

Thanks!