Need help with Access formula builder - Simple Sum

[mbelc]

Hi,



I am trying to get a simple sum to show up in a computed field in access...basically, for every individual record, I have a number that has been inputted for every month, and I would like the total for six months to show up in another box titled "Term 2 total." I have tried to type the following formula into the term 2 total box, but I keep getting odd or incorrect sums across records.


=Sum([Jul])+([Aug])+([Sep])+([Oct])+([Nov])+([Dec])



(The source titles are typed in correctly.) I am not sure what I am doing wrong. Please help me out!



Thanks in advance.

[alansidman]

I assume that this is in a Form. Try this:

=[Jul]+[Aug]+[Sep]+[Oct]+[Nov]+[Dec]

[mbelc]

I assume that this is in a Form. Try this:

=[Jul]+[Aug]+[Sep]+[Oct]+[Nov]+[Dec]

I did try this first -- whenever I do this, I get a weird output. For instance, if I put a "1" under all six months, I get a value that is "111111". (And if I were to put a "2" in each box, the output is "222222" etc.)

[ssanfu]

=Sum([Jul])+([Aug])+([Sep])+([Oct])+([Nov])+([Dec])

This is saying take the sum (ie total)of all of the [Jul] field's in the current recordset AND add the values from the current record fields [Aug], [Sep], [Oct], [Nov] and [Dec].
So would expect the result would vary for each record....

[mbelc]

=Sum([Jul])+([Aug])+([Sep])+([Oct])+([Nov])+([Dec])

This is saying take the sum (ie total)of all of the [Jul] field's in the current recordset AND add the values from the current record fields [Aug], [Sep], [Oct], [Nov] and [Dec].
So would expect the result would vary for each record....

Okay good to know, so how do I just get the sum of those fields for the current record only? (Please see my above post when I stated that simply typing [Jul]+[Aug]...etc. for some reason resulted in a calculation that was all of the numbers in succession and not a sum.

[ssanfu]

Alan's formula in Post #2 should have worked.

I did try this first -- whenever I do this, I get a weird output. For instance, if I put a "1" under all six months, I get a value that is "111111". (And if I were to put a "2" in each box, the output is "222222" etc.

It sounds like the fields are Text type and the values are being concatenated.
Are [Jul], [Aug], [Sep], [Oct] ,[Nov] and [Dec] fields in a table?
If they are fields in a table, what are the field types? Number or Text?

[mbelc]

Alan's formula in Post #2 should have worked.


It sounds like the fields are Text type and the values are being concatenated.
Are [Jul], [Aug], [Sep], [Oct] ,[Nov] and [Dec] fields in a table?
If they are fields in a table, what are the field types? Number or Text?

Thank you so much!! Sorry I am quite the beginner -- the field types were text, when I changed them to numbers it worked perfectly.

You are wonderful, thanks everyone for the help!