When text field is used in Sum() function, it is adding them like the field is number

[teja]

Hi all,



I have an access database that imports data from a Excel sheet. All the columns are text datatypes.

when i run the query - Select Sum(Tablename.column1) From Tablename group by column2;

where the column1 has numbers (but the column type is "Text"), the result is same as when a number datatype field is added.

Kindly explain.

Also, similar observation is made incase of SELECT col1+col2 FROM table;

where col1 and col2 are text datatype but have number values. I thought the result will give concatenated string instead of added up value.

Does access internally recognize them as numbers????

Thanks in advance.

[Bob Fitz]

To get a concatenated string, use & instead of +

[teja]

To get a concatenated string, use & instead of +

But why the result is addition for text type.... I mean if the column type is text... and i am using that column in Sum() function then datatype mismatch error must be shown... I guess!