If this is a crosstab, the query will automatically sum the columns unless you tell it not to.
If the quarters are separate columns in your table, the best solution would be to normalize the table so that each quarter is in a separate row. Then use a crosstab to present the data.
