Calculated Field

[crcastilla]

So I have two columns as follows..

A B
1 4
6 3
2 0

Now I added an extra column in a query so that column shows the total of A and B per row but instead of add them it does this..

C
14
63
29

So it looks put the numbers from column A and B together but do not add them. I typed this on the as the calculated field.

C: [A]+[B]

What is causing this problem?

Please help and thank you in advance!

[R_Badger]

It think it should be C:=[a]+[b]

I'm not totally sure as I don't usually use 2007 (2003 mostly)
Please post back and let us all know how you get on!

[crcastilla]

Thank you!

My mistake was that column A and B were text data type instead of number data type.