Simply use addition, to get the sum of specific culumn values. You will get as many rows as your selection gives:

SQL

Copy Code

SELECT [index]+[01]+[02]+...+[at] as [SUM] FROM [count];

You can summarize each column on it's own. You will get one row, with as many values, as many columns you add:

SQL

Copy Code

SELECT SUM([index]), SUM([01]), SUM([02]),...,SUM([at]) FROM [count];

And of course, you can combine these, to get the sum of all:

SQL

Copy Code

SELECT SUM([index]+[01]+[02]+...+[at]) as [SUM] FROM [count];