How to calculate record of similar values in one column.

[irslan rafique]

Hi,
I am working in Query, Access 2010
I have two Columns in query, Like:

Column A

Column B

A

1

A

2

B

3

B

4

B

1

I want to show the total of A (3) and B(8) in column C

Please advice.
Thanks in advance

[twinnyfo]

Use an aggregate query with the Sum Function.

SELECT Sum([Column A]) AS SumOfA, 
    Sum([Column B]) AS SumOfB 
FROM [TableName] 
GROUP BY [Column A];

There is no need to have a separate column for the totals.